{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Note Balance","Cumulative Defaults","Collateral Tables"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":8,"defined_names":24,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Note Balance","index":0,"n_rows":240,"n_cols":9,"rows_kept":240,"cut":false,"hidden":false,"merged":[]}
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes","Class D Notes"]
[null,null,"Initial Invested Amount",{"$f":"SUM(E3:I3)","v":331000000},105000000,198000000,11300000,10500000,6200000]
["(a)",null,"Invested Amount as at Previous Payment Date:  3 March 2016",{"$f":"SUM(E4:I4)","v":331000000},105000000,198000000,11300000,10500000,6200000]
["(b)",null,"Stated Amount as at Previous Payment Date:  3 March 2016",331000000,105000000,198000000,11300000,10500000,6200000]
["(d)",null,"Principal Payments to Noteholders on Payment Date",74839799.260000005,74839799.260000005,0,0,0,0]
[null,null,"Gross Aggregate Charge-Offs",0,0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0,0]
["(e)",null,"Aggregate Charge-Offs for this Collection Period",0,0,0,0,0,0]
["(f)",null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 May 2016",{"$f":"SUM(E14:I14)","v":256160200.74000001},30160200.739999995,198000000,11300000,10500000,6200000]
[null,null,"Stated Amount as at Payment Date:  16 May 2016",{"$f":"SUM(E15:I15)","v":256160200.74000001},30160200.739999995,198000000,11300000,10500000,6200000]
[null,null,"Bond Factor at Payment Date:  16 May 2016",null,0.28724000704761898,1,1,1,1]
[null,null,"Coupon Margin",null,6.0000000000000001E-3,1.2999999999999999E-2,0.02,2.5000000000000001E-2,2.4500000000000001E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.9100000000000001E-2,3.61E-2,4.3099999999999999E-2,4.8100000000000004E-2,4.7600000000000003E-2]
[null,null,"Days in Coupon Period",null,74,74,74,74,74]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 May 2016",null,619471.23,1449143.01,98740.33,102393.7,59832.55]
[]
[]
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes","Class D Notes"]
[null,null,"Initial Invested Amount",{"$f":"SUM(E25:I25)","v":331000000},105000000,198000000,11300000,10500000,6200000]
["(a)",null,"Invested Amount as at Previous Payment Date:  16 May 2016",{"$f":"SUM(E26:I26)","v":256160200.74000001},30160200.739999995,198000000,11300000,10500000,6200000]
["(b)",null,"Stated Amount as at Previous Payment Date:  16 May 2016",256160200.74000001,30160200.739999995,198000000,11300000,10500000,6200000]
["(d)",null,"Principal Payments to Noteholders on Payment Date",21349482.670000002,21349482.670000002,0,0,0,0]
[null,null,"Gross Aggregate Charge-Offs",0,0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0,0]
["(e)",null,"Aggregate Charge-Offs for this Collection Period",{"$f":"SUM(E31:I31)","v":0},0,0,0,0,0]
["(f)",null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",{"$f":"SUM(E32:I32)","v":0},0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",{"$f":"SUM(E33:I33)","v":0},0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",{"$f":"SUM(D31:D34)","v":0},0,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 August 2016",{"$f":"SUM(E36:I36)","v":234810718.06999999},8810718.0699999928,198000000,11300000,10500000,6200000]
[null,null,"Stated Amount as at Payment Date:  16 August 2016",{"$f":"SUM(E37:I37)","v":234810718.06999999},8810718.0699999928,198000000,11300000,10500000,6200000]
[null,null,"Bond Factor at Payment Date:  16 August 2016",null,8.39116006666666E-2,1,1,1,1]
[null,null,"Coupon Margin",null,6.0000000000000001E-3,1.2999999999999999E-2,0.02,2.5000000000000001E-2,2.4500000000000001E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.5849999999999998E-2,3.2849999999999997E-2,3.9849999999999997E-2,4.4850000000000001E-2,4.4350000000000001E-2]
[null,null,"Days in Coupon Period",null,92,92,92,92,92]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 August 2016",null,196512.3,1639440,113501.53,118698.9,69307.509999999995]
[]
[]
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes","Class D Notes"]
[null,null,"Initial Invested Amount",{"$f":"SUM(E47:I47)","v":331000000},105000000,198000000,11300000,10500000,6200000]
["(a)",null,"Invested Amount as at Previous Payment Date:  16 August 2016",{"$f":"SUM(E48:I48)","v":234810718.06999999},8810718.0699999928,198000000,11300000,10500000,6200000]
["(b)",null,"Stated Amount as at Previous Payment Date:  16 August 2016",{"$f":"SUM(E49:I49)","v":234810718.06999999},8810718.0699999928,198000000,11300000,10500000,6200000]
["(d)",null,"Principal Payments to Noteholders on Payment Date",{"$f":"SUM(E50:I50)","v":20385939.140000001},8810718.0700000003,11575221.07,0,0,0]
[null,null,"Gross Aggregate Charge-Offs",0,0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0,0]
["(e)",null,"Aggregate Charge-Offs for this Collection Period",0,0,0,0,0,0]
["(f)",null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",{"$f":"SUM(D53:D56)","v":0},0,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 November 2016",{"$f":"SUM(E58:I58)","v":214424778.93000001},0,186424778.93000001,11300000,10500000,6200000]
[null,null,"Stated Amount as at Payment Date:  16 November 2016",{"$f":"SUM(E59:I59)","v":214424778.93000001},-7.4505805969238281E-9,186424778.93000001,11300000,10500000,6200000]
[null,null,"Bond Factor at Payment Date:  16 November 2016",null,-7.0957910446893603E-17,0.94153928752525251,1,1,1]
[null,null,"Coupon Margin",null,6.0000000000000001E-3,1.2999999999999999E-2,0.02,2.5000000000000001E-2,2.4500000000000001E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.3550000000000001E-2,3.0550000000000001E-2,3.755E-2,4.2550000000000004E-2,4.2050000000000004E-2]
[null,null,"Days in Coupon Period",null,92,92,92,92,92]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 November 2016",null,52299.46,1524654.25,106950.63,112611.78,65713.210000000006]
[]
[]
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes","Class D Notes"]
[null,null,"Initial Invested Amount",{"$f":"SUM(E69:I69)","v":331000000},105000000,198000000,11300000,10500000,6200000]
["(a)",null,"Invested Amount as at Previous Payment Date:  16 November 2016",{"$f":"SUM(E70:I70)","v":214424778.93000001},0,186424778.93000001,11300000,10500000,6200000]
["(b)",null,"Stated Amount as at Previous Payment Date:  16 November 2016",214424778.93000001,-7.4505805969238281E-9,186424778.93000001,11300000,10500000,6200000]
["(d)",null,"Principal Payments to Noteholders on Payment Date",19109971.649999999,0,19109971.649999999,0,0,0]
[null,null,"Gross Aggregate Charge-Offs",0,0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0,0]
["(e)",null,"Aggregate Charge-Offs for this Collection Period",-7.4505805969238281E-9,-7.4505805969238281E-9,0,0,0,0]
["(f)",null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",{"$f":"SUM(D75:D78)","v":-7.4505805969238281E-9},-7.4505805969238281E-9,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 February 2017",{"$f":"SUM(E80:I80)","v":195314807.28},0,167314807.28,11300000,10500000,6200000]
[null,null,"Stated Amount as at Payment Date:  16 February 2017",{"$f":"SUM(E81:I81)","v":195314807.28},0,167314807.28,11300000,10500000,6200000]
[null,null,"Bond Factor at Payment Date:  16 February 2017",null,0,0.84502427919191925,1,1,1]
[null,null,"Coupon Margin",null,6.0000000000000001E-3,1.2999999999999999E-2,0.02,2.5000000000000001E-2,2.4500000000000001E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.3600000000000003E-2,3.0600000000000002E-2,3.7600000000000001E-2,4.2599999999999999E-2,4.2099999999999999E-2]
[null,null,"Days in Coupon Period",null,92,92,92,92,92]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 February 2017",null,0,1437871.34,107093.04,112744.11,65791.34]
[]
[]
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes","Class D Notes"]
[null,null,"Initial Invested Amount",{"$f":"SUM(E91:I91)","v":331000000},105000000,198000000,11300000,10500000,6200000]
["(a)",null,"Invested Amount as at Previous Payment Date:  16 February 2017",{"$f":"SUM(E92:I92)","v":195314807.28},0,167314807.28,11300000,10500000,6200000]
["(b)",null,"Stated Amount as at Previous Payment Date:  16 February 2017",195314807.28,0,167314807.28,11300000,10500000,6200000]
["(d)",null,"Principal Payments to Noteholders on Payment Date",53461683.039999999,0,53461683.039999999,0,0,0]
[null,null,"Gross Aggregate Charge-Offs",0,0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0,0]
["(e)",null,"Aggregate Charge-Offs for this Collection Period",-7.4505805969238281E-9,0,0,0,0,0]
["(f)",null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",{"$f":"SUM(D97:D100)","v":-7.4505805969238281E-9},0,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 May 2017",{"$f":"SUM(E102:I102)","v":141853124.24000001},0,113853124.24000001,11300000,10500000,6200000]
[null,null,"Stated Amount as at Payment Date:  16 May 2017",141853124.24000001,0,113853124.24000001,11300000,10500000,6200000]
[null,null,"Bond Factor at Payment Date:  16 May 2017",null,0,0.57501577898989908,1,1,1]
[null,null,"Coupon Margin",null,6.0000000000000001E-3,1.2999999999999999E-2,0.02,2.5000000000000001E-2,2.4500000000000001E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.3800000000000002E-2,3.0800000000000001E-2,3.78E-2,4.2800000000000005E-2,4.2300000000000004E-2]
[null,null,"Days in Coupon Period",null,89,89,89,89,89]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 May 2017",null,0,1256557.1200000001,104151.95,109579.73,63948.33]
[]
[]
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes","Class D Notes"]
[null,null,"Initial Invested Amount",{"$f":"SUM(E113:I113)","v":331000000},105000000,198000000,11300000,10500000,6200000]
["(a)",null,"Invested Amount as at Previous Payment Date:  16 May 2017",{"$f":"SUM(E114:I114)","v":141853124.24000001},0,113853124.24000001,11300000,10500000,6200000]
["(b)",null,"Stated Amount as at Previous Payment Date:  16 May 2017",141853124.24000001,0,113853124.24000001,11300000,10500000,6200000]
["(d)",null,"Principal Payments to Noteholders on Payment Date",17286743.239999998,0,17286743.239999998,0,0,0]
[null,null,"Gross Aggregate Charge-Offs",0,0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0,0]
["(e)",null,"Aggregate Charge-Offs for this Collection Period",-7.4505805969238281E-9,0,0,0,0,0]
["(f)",null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",{"$f":"SUM(D119:D122)","v":-7.4505805969238281E-9},0,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 August 2017",{"$f":"SUM(E124:I124)","v":124566381.00000001},0,96566381.000000015,11300000,10500000,6200000]
[null,null,"Stated Amount as at Payment Date:  16 August 2017",124566381.00000001,0,96566381.000000015,11300000,10500000,6200000]
[null,null,"Bond Factor at Payment Date:  16 August 2017",null,0,0.48770899494949504,1,1,1]
[null,null,"Coupon Margin",null,6.0000000000000001E-3,1.2999999999999999E-2,0.02,2.5000000000000001E-2,2.4500000000000001E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.3350000000000003E-2,3.0350000000000002E-2,3.7350000000000001E-2,4.2349999999999999E-2,4.1849999999999998E-2]
[null,null,"Days in Coupon Period",null,92,92,92,92,92]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 August 2017",null,0,870960.8,106380.99,112082.47,65400.66]
[]
[]
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes","Class D Notes"]
[null,null,"Initial Invested Amount",{"$f":"SUM(E135:I135)","v":331000000},105000000,198000000,11300000,10500000,6200000]
[null,null,"Invested Amount as at Previous Payment Date:  16 August 2017",{"$f":"SUM(E136:I136)","v":124566381.00000001},0,96566381.000000015,11300000,10500000,6200000]
[null,null,"Stated Amount as at Previous Payment Date:  16 August 2017",124566381.00000001,0,96566381.000000015,11300000,10500000,6200000]
[null,null,"Principal Payments to Noteholders on Payment Date",15655432.369999999,0,15655432.369999999,0,0,0]
[null,null,"Gross Aggregate Charge-Offs",0,0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs for this Collection Period",-7.4505805969238281E-9,0,0,0,0,0]
[null,null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",{"$f":"SUM(D141:D144)","v":-7.4505805969238281E-9},0,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 November 2017",{"$f":"SUM(E146:I146)","v":108910948.63000001},0,80910948.63000001,11300000,10500000,6200000]
[null,null,"Stated Amount as at Payment Date:  16 November 2017",108910948.63000001,0,80910948.63000001,11300000,10500000,6200000]
[null,null,"Bond Factor at Payment Date:  16 November 2017",null,0,0.40864115469696977,1,1,1]
[null,null,"Coupon Margin",null,6.0000000000000001E-3,1.2999999999999999E-2,0.02,2.5000000000000001E-2,2.4500000000000001E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.2899999999999997E-2,2.9899999999999996E-2,3.6900000000000002E-2,4.19E-2,4.1399999999999999E-2]
[null,null,"Days in Coupon Period",null,92,92,92,92,92]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 November 2017",null,0,727766.58,105099.29,110891.51,64697.42]
[]
[]
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes","Class D Notes"]
[null,null,"Initial Invested Amount",{"$f":"SUM(E157:I157)","v":331000000},105000000,198000000,11300000,10500000,6200000]
[null,null,"Invested Amount as at Previous Payment Date:  16 November 2017",{"$f":"SUM(E158:I158)","v":108910948.63000001},0,80910948.63000001,11300000,10500000,6200000]
[null,null,"Stated Amount as at Previous Payment Date:  16 November 2017",108910948.63000001,0,80910948.63000001,11300000,10500000,6200000]
[null,null,"Principal Payments to Noteholders on Payment Date",14266198.109999999,0,14266198.109999999,0,0,0]
[null,null,"Gross Aggregate Charge-Offs",0,0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs for this Collection Period",-7.4505805969238281E-9,0,0,0,0,0]
[null,null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",{"$f":"SUM(D163:D166)","v":-7.4505805969238281E-9},0,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 February 2018",{"$f":"SUM(E168:I168)","v":94644750.520000011},0,66644750.520000011,11300000,10500000,6200000]
[null,null,"Stated Amount as at Payment Date:  16 February 2018",94644750.520000011,0,66644750.520000011,11300000,10500000,6200000]
[null,null,"Bond Factor at Payment Date:  16 February 2018",null,0,0.33658964909090916,1,1,1]
[null,null,"Coupon Margin",null,6.0000000000000001E-3,1.2999999999999999E-2,0.02,2.5000000000000001E-2,2.4500000000000001E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.3199999999999998E-2,3.0199999999999998E-2,3.7199999999999997E-2,4.2200000000000001E-2,4.1700000000000001E-2]
[null,null,"Days in Coupon Period",null,92,92,92,92,92]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 February 2018",null,0,615898.56999999995,105953.75,111685.48,65166.25]
[]
[]
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes","Class D Notes"]
[null,null,"Initial Invested Amount",{"$f":"SUM(E179:I179)","v":331000000},105000000,198000000,11300000,10500000,6200000]
[null,null,"Invested Amount as at Previous Payment Date:  16 February 2018",{"$f":"SUM(E180:I180)","v":94644750.520000011},0,66644750.520000011,11300000,10500000,6200000]
[null,null,"Stated Amount as at Previous Payment Date:  16 February 2018",94644750.520000011,0,66644750.520000011,11300000,10500000,6200000]
[null,null,"Principal Payments to Noteholders on Payment Date",38893734.189999998,0,38893734.189999998,0,0,0]
[null,null,"Gross Aggregate Charge-Offs",0,0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs for this Collection Period",-7.4505805969238281E-9,0,0,0,0,0]
[null,null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",{"$f":"SUM(D185:D188)","v":-7.4505805969238281E-9},0,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 May 2018",{"$f":"SUM(E190:I190)","v":55751016.330000013},0,27751016.330000013,11300000,10500000,6200000]
[null,null,"Stated Amount as at Payment Date:  16 May 2018",55751016.330000013,0,27751016.330000013,11300000,10500000,6200000]
[null,null,"Bond Factor at Payment Date:  16 May 2018",null,0,0.14015664813131321,1,1,1]
[null,null,"Coupon Margin",null,6.0000000000000001E-3,1.2999999999999999E-2,0.02,2.5000000000000001E-2,2.4500000000000001E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.3649999999999997E-2,3.0649999999999997E-2,3.7650000000000003E-2,4.265E-2,4.215E-2]
[null,null,"Days in Coupon Period",null,89,89,89,89,89]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 May 2018",null,0,498073.65,103738.64,109195.68,63721.56]
[]
[]
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes","Class D Notes"]
[null,null,"Initial Invested Amount",{"$f":"SUM(E201:I201)","v":331000000},105000000,198000000,11300000,10500000,6200000]
[null,null,"Invested Amount as at Previous Payment Date:  16 May 2018",{"$f":"SUM(E202:I202)","v":55751016.330000013},0,27751016.330000013,11300000,10500000,6200000]
[null,null,"Stated Amount as at Previous Payment Date:  16 May 2018",55751016.330000013,0,27751016.330000013,11300000,10500000,6200000]
[null,null,"Principal Payments to Noteholders on Payment Date",10427489.939999999,0,10427489.939999999,0,0,0]
[null,null,"Gross Aggregate Charge-Offs",{"$f":"SUM(E205:J205)","v":0},0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs for this Collection Period",0,0,0,0,0,0]
[null,null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 August 2018",{"$f":"SUM(E212:I212)","v":45323526.390000015},0,17323526.390000015,11300000,10500000,6200000]
[null,null,"Stated Amount as at Payment Date:  16 August 2018",{"$f":"SUM(E213:I213)","v":45323526.390000015},0,17323526.390000015,11300000,10500000,6200000]
[null,null,"Bond Factor at Payment Date:  16 August 2018",null,0,8.7492557525252604E-2,1,1,1]
[null,null,"Coupon Margin",null,6.0000000000000001E-3,1.2999999999999999E-2,0.02,2.5000000000000001E-2,2.4500000000000001E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.5000000000000001E-2,3.2000000000000001E-2,3.9E-2,4.3999999999999997E-2,4.3499999999999997E-2]
[null,null,"Days in Coupon Period",null,92,92,92,92,92]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 August 2018",null,0,223832.86,111080.55,116449.32,67979.179999999993]
[]
[]
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes","Class D Notes"]
[null,null,"Initial Invested Amount",{"$f":"SUM(E223:I223)","v":331000000},105000000,198000000,11300000,10500000,6200000]
[null,null,"Invested Amount as at Previous Payment Date:  16 August 2018",{"$f":"SUM(E224:I224)","v":45323526.390000015},0,17323526.390000015,11300000,10500000,6200000]
[null,null,"Stated Amount as at Previous Payment Date:  16 August 2018",45323526.390000015,0,17323526.390000015,11300000,10500000,6200000]
[null,null,"Principal Payments to Noteholders on Payment Date",8198270.7199999997,0,8198270.7199999997,0,0,0]
[null,null,"Gross Aggregate Charge-Offs",{"$f":"SUM(E227:I227)","v":0},0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs for this Collection Period",0,0,0,0,0,0]
[null,null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0,0]
[null,null,"Invested Amount as at Payment Date:  16 November 2018",{"$f":"SUM(E234:I234)","v":37125255.670000017},0,9125255.6700000167,11300000,10500000,6200000]
[null,null,"Stated Amount as at Payment Date:  16 November 2018",{"$f":"SUM(E235:I235)","v":37125255.670000017},0,9125255.6700000167,11300000,10500000,6200000]
[null,null,"Bond Factor at Payment Date:  16 November 2018",null,0,4.6087149848484936E-2,1,1,1]
[null,null,"Coupon Margin",null,6.0000000000000001E-3,1.2999999999999999E-2,0.02,2.5000000000000001E-2,2.4500000000000001E-2]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,2.5550000000000003E-2,3.2550000000000003E-2,3.9550000000000002E-2,4.4550000000000006E-2,4.4050000000000006E-2]
[null,null,"Days in Coupon Period",null,92,92,92,92,92]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 November 2018",null,0,142128.85999999999,112647.07,117904.93,68838.679999999993]

{"sheet":"Cumulative Defaults","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Cumulative Defaults & Losses"]
[]
["Month","Gross Losses","Recoveries","Net Losses"]
["2016-04-01",2.4018917142857145E-4,0,{"$f":"B4-C4","v":2.4018917142857145E-4}]
["2016-07-01",1.2563261142857142E-3,-2.4793114285714286E-5,1.2811192285714285E-3]
["2016-10-01",1.2563261142857142E-3,2.3424894285714297E-4,1.0220771714285713E-3]
["2017-01-01",1.2563261142857142E-3,2.9124894285714303E-4,9.6507717142857116E-4]
["2017-04-01",1.2935662857142857E-3,4.2511100000000015E-4,8.6845528571428553E-4]
["2017-07-01",1.2935662857142857E-3,5.5897305714285733E-4,7.3459322857142835E-4]
["2017-10-01",2.3818699142857144E-3,5.8754448571428591E-4,1.7943254285714286E-3]
["2018-01-01",3.043033085714286E-3,1.7731556000000004E-3,1.2698774857142856E-3]
["2018-04-01",3.043033085714286E-3,2.5570584571428575E-3,4.8597462857142854E-4]
["2018-07-01",3.043033085714286E-3,2.5570584571428575E-3,4.8597462857142854E-4]
["2018-10-01",{"$f":"B13+'Collateral Tables'!E9/350000000","v":3.043033085714286E-3},{"$f":"+C13+'Collateral Tables'!E23/350000000","v":2.5570584571428575E-3},{"$f":"B14-C14","v":4.8597462857142854E-4}]

{"sheet":"Collateral Tables","index":2,"n_rows":247,"n_cols":47,"rows_kept":247,"cut":false,"hidden":false,"merged":[]}
[null,"CNH CAPITAL AUSTRALIA RECEIVABLES TRUST SERIES 2016-1 (TERM DEAL)"]
[null,"COLLATERAL DATA TABLES"]
[]
[null,"OUTSTANDING RECEIVABLES",null,null,"2018-10-31",null,null,null,"2018-07-31",null,null,null,"2018-04-30",null,null,null,"2018-01-31",null,null,null,"2017-10-31",null,null,null,"2017-07-31",null,null,null,"2017-04-30",null,null,null,"2017-01-31",null,null,null,"2016-10-31",null,null,null,"2016-07-31",null,null,null,"2016-04-30"]
[]
[null,"Opening Balance",null,null,{"$f":"I13","v":63258464.810000174},null,null,null,73685954.750000164,null,null,null,112579688.94000019,null,null,null,127077294.16000021,null,null,null,143113632.80000019,null,null,null,160400376.04000017,null,null,null,213875093.14000008,null,null,null,232985064.79000005,null,null,null,253371003.93000007,null,null,null,275076134.53000009,null,null,null,349999833.42000002]
[null,"Principal Repayments - Scheduled",null,null,{"$f":"MIN('[1]16 Nov 18'!M156,SUM([2]Sheet1!$B$3+[3]Sheet1!$B$3+[4]Sheet1!$B$3))","v":6829749.7400000002},null,null,null,9010185.3100000042,null,null,null,37756769.780000009,null,null,null,12294141.17,null,null,null,10996073.130000001,null,null,null,14256110.440000001,null,null,null,51949874.479999982,null,null,null,19109971.64999998,null,null,null,13038858.939999998,null,null,null,18368178.68,null,null,null,70539694.680000007]
[null,"Principal Repayments - Unscheduled",null,null,{"$f":"'[1]16 Nov 18'!$H$23-'Collateral Tables'!E7","v":1368520.9800000023},null,null,null,1417304.6299999859,null,null,null,1136964.4100000113,null,null,null,1972056.9400000144,null,null,null,4659359.2399999928,null,null,null,3030632.799999997,null,null,null,1511808.559999913,null,null,null,0,null,null,null,7347080.2000000104,null,null,null,2981303.9900000058,null,null,null,4299937.9999999255]
[{"$f":"SUM(AO9:AS9)","v":439714.14},"Charge-Offs",null,null,{"$f":"'[1]16 Nov 18'!$H37","v":0},null,null,null,0,null,null,null,0,null,null,null,231407.11,null,null,null,380906.27,null,null,null,0,null,null,null,13034.06,null,null,null,0,null,null,null,0,null,null,null,355647.93,null,null,null,84066.21]
[null,"Reinstatements"]
[null,"New Receivables Purchased"]
[null,"Non Cash Change in Receivables"]
[null,"Closing Balance",null,null,{"$f":"E6-E7-E8-E9+E10+E11-E12","v":55060194.090000167},null,null,null,63258464.810000174,null,null,null,73685954.750000164,null,null,null,112579688.94000019,null,null,null,127077294.16000021,null,null,null,143113632.80000019,null,null,null,160400376.04000017,null,null,null,213875093.14000008,null,null,null,232985064.79000005,null,null,null,253371003.93000007,null,null,null,275076134.53000009]
[]
[null,"PORTFOLIO STATISTICS"]
[]
[null,"Summary"]
[null,"Number of contracts",null,null,{"$f":"[5]Summary!$B$4","v":1208},null,null,null,1436,null,null,null,1693,null,null,null,2074,null,null,null,2233,null,null,null,2472,null,null,null,2690,null,null,null,3006,null,null,null,3133,null,null,null,3263,null,null,null,3422]
[null,"Average Dollar Value of Loans",null,null,{"$f":"[5]Summary!$B$6","v":45579.630869205386},null,null,null,44051.855717270279,null,null,null,43523.895304193786,null,null,null,54281.431504339482,null,null,null,56908.774814151344,null,null,null,57893.864401294602,null,null,null,59628.392579925814,null,null,null,71149.398915502403,null,null,null,74364.846725183495,null,null,null,77649.710061293183,null,null,null,80384.609739918029]
[null,"Number of contracts closed during the Quarter",null,null,{"$f":"[5]Summary!$B$19","v":228},null,null,null,257,null,null,null,381,null,null,null,157,null,null,null,238,null,null,null,218,null,null,null,315,null,null,null,127,null,null,null,130,null,null,null,157,null,null,null,216]
[null,"Dollar value of contracts closed during the Quarter",null,null,{"$f":"[5]Summary!$B$20","v":4167402.6399999987},null,null,null,4804492.9099999974,null,null,null,13453522.929999985,null,null,null,4423245.9000000013,null,null,null,7890618.4899999984,null,null,null,6562238.0599999968,null,null,null,11939537.530000001,null,null,null,4405939.9600000018,null,null,null,8722235.7299999949,null,null,null,5997812.8599999985,null,null,null,10129289.880000003]
[]
[{"$f":"SUM(AS23)","v":0},"Dollar Value of Recoveries from Collateral",null,null,{"$f":"[5]Summary!$C$16","v":0},null,null,null,0,null,null,null,274366,null,null,null,414963.89000000007,null,null,null,10000,null,null,null,69482.69,null,null,null,46851.72,null,null,null,19950.000000000015,null,null,null,90664.72000000003,null,null,null,-8677.59,null,null,null,0]
[null,"Dollar Value of Recoveries from Other Sources",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[]
[null,"Average Term of Contracts (Months)",null,null,{"$f":"[6]Sheet1!$W$1210","v":55.588696698144773},null,null,null,55.216018737271511,null,null,null,54.809650656660473,null,null,null,53.536552206607894,null,null,null,53.165234625656645,null,null,null,52.808167788959686,null,null,null,52.448670668714705,null,null,null,51.548659039522505,null,null,null,51.221268983771495,null,null,null,50.905018498380905,null,null,null,50.602561692977268]
[null,"Average Term to Maturity (Months)",null,null,{"$f":"[6]Sheet1!$X$1210","v":12.362141815145188},null,null,null,14.848700248279059,null,null,null,17.198840563167145,null,null,null,18.014605674926596,null,null,null,20.352376250895166,null,null,null,22.772484506870782,null,null,null,25.111819899695959,null,null,null,26.298385029893218,null,null,null,28.796062261189039,null,null,null,31.261824556602878,null,null,null,33.580143025830573]
[null,"Average Residual / Balloon Payment *",null,null,{"$f":"[6]Sheet1!$AI$1210","v":2.7021944331856125E-2},null,null,null,2.6496906490445445E-2,null,null,null,2.8536757481773027E-2,null,null,null,2.1992720189062769E-2,null,null,null,2.0618780571606873E-2,null,null,null,2.2334975567803873E-2,null,null,null,2.2751675967038917E-2,null,null,null,1.9662870213616519E-2,null,null,null,1.9947715214700443E-2,null,null,null,2.2629991788590827E-2,null,null,null,2.4040809082651878E-2]
[null,"Average Seasoning (Months)",null,null,{"$f":"E26-E27","v":43.226554882999586},null,null,null,40.367318488992453,null,null,null,37.610810093493328,null,null,null,35.521946531681294,null,null,null,32.812858374761475,null,null,null,30.035683282088904,null,null,null,27.336850769018746,null,null,null,25.250274009629287,null,null,null,22.425206722582455,null,null,null,19.643193941778026,null,null,null,17.022418667146695]
[null,"Average Dollar Value of Individual Assets",null,null,{"$f":"E19/E18","v":37.731482507620356},null,null,null,30.676779747402701,null,null,null,25.708148437208379,null,null,null,26.172339201706595,null,null,null,25.48534474435797,null,null,null,23.419848058776132,null,null,null,22.166688691422237,null,null,null,23.669128049069329,null,null,null,23.73598682578471,null,null,null,23.797030358962054,null,null,null,23.490534698982476]
[null,"Weighted Average Interest Rate",null,null,{"$f":"[6]Sheet1!$AA$1210/100","v":3.4826200185937954E-2},null,null,null,3.4812214042108172E-2,null,null,null,3.4876817684175568E-2,null,null,null,3.508781027725897E-2,null,null,null,3.549832767872909E-2,null,null,null,3.571777101991367E-2,null,null,null,3.5843774343977945E-2,null,null,null,3.6137323863452482E-2,null,null,null,3.6244089599937843E-2,null,null,null,3.6462237991813522E-2,null,null,null,3.6655471442132145E-2]
[]
[null,"Payment in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,{"$f":"IFERROR(VLOOKUP($A34,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":1200},{"$f":"IFERROR(VLOOKUP($A34,'[7]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":15032.539999999992},{"$f":"F34/F$50","v":2.7302010551267131E-4},null,1433,52325.420000000013,8.271686667888948E-4,null,1687,111762.89,1.5167461747518428E-3,null,2069,31286.35,2.7790403663909767E-4,null,2221,48260.540000000008,3.7977311618892613E-4,null,2463,31851.469999999998,2.225606979351303E-4,null,2677,243095.85999999993,1.5155566713844673E-3,null,2997,43406.450000000004,2.0295233709886277E-4,null,3124,20933.35999999999,8.9848506035647343E-5,null,3255,120639.01000000001,4.7613581715660603E-4,null,3409,279917.05,1.0175984567991395E-3]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP($A35,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":3},{"$f":"IFERROR(VLOOKUP($A35,'[7]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":206132.85000000003},{"$f":"F35/F$50","v":3.7437726729233839E-3},null,3,110344.49000000002,1.7443434697858235E-3,null,5,165307.78999999998,2.243409759171232E-3,null,3,27999.160000000003,2.4870525281804872E-4,null,7,118171.85999999999,9.2992112226762279E-4,null,2,46643.609999999986,3.2592010339912162E-4,null,8,242973.24999999994,1.5147922716802584E-3,null,2,63265.990000000005,2.9580812366303353E-4,null,6,106352.71000000002,4.5647865924736678E-4,null,3,46074.110000000015,1.8184444662313923E-4,null,8,230113.48,8.3654469113860581E-4]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP($A36,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":2},{"$f":"IFERROR(VLOOKUP($A36,'[7]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":35953.61},6.5298734583519745E-4,null,0,0,0,null,1,3042.8799999999937,4.1295251046468807E-5,null,2,21324.730000000003,1.8941898135253445E-4,null,3,113940.22,8.966213889992072E-4,null,2,23394.389999999992,1.6346723608570127E-4,null,3,16262.82,1.0138891442464199E-4,null,6,45416.01,2.1234828858856972E-4,null,0,0,0,null,4,60199.999999999971,2.3759624845087562E-4,null,3,35237.550000000097,1.2810108030712178E-4]
["4. 91 - 120 Days","91 - 120 Days",null,null,{"$f":"IFERROR(VLOOKUP($A37,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A37,'[7]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":4371.5599999999959},7.9396015074962244E-5,null,0,0,0,null,0,0,0,null,0,0,0,null,2,27079.119999999992,2.1309172640948212E-4,null,3,25252.480000000003,1.7645055544980877E-4,null,2,106676.20999999999,6.6506209420230547E-4,null,0,0,0,null,3,19683.799999999992,8.4485243797673918E-5,null,0,0,0,null,1,48099.140000000007,1.7485755382662749E-4]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP($A38,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":2},{"$f":"IFERROR(VLOOKUP($A38,'[7]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,2,0,0,null,0,0,0,null,1,2664.4000000000015,1.2457738584155356E-5,null,0,0,0,null,1,5363.4499999999989,2.1168365427804805E-5,null,1,30045.720000000012,1.09226923852688E-4]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP($A39,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A39,'[7]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Total",null,null,{"$f":"SUM(E34:E39)","v":1208},{"$f":"SUM(F34:F39)","v":261490.56},{"$f":"SUM(G34:G39)","v":4.7491761393462142E-3},null,1436,162669.91000000003,2.5715121365747183E-3,null,1693,280113.56,3.8014511849695436E-3,null,2074,80610.240000000005,7.1602827080968073E-4,null,2233,307451.74,2.419407353865238E-3,null,2472,127141.94999999998,8.8839859286976195E-4,null,2690,609008.1399999999,3.796799951691673E-3,null,3006,154752.85,7.2356648793462134E-4,null,3133,146969.87,6.3081240908068807E-4,null,3263,232276.57,9.1674487765842569E-4,null,3422,623412.94000000006,2.2663287059241826E-3]
[null,"* Expressed as a % of Aggreg. Rec. closing bal.",null,null,null,"> 30 days",{"$f":"SUM(G35:G39)","v":4.476156033833543E-3},null,null,"> 30 days",1.7443434697858235E-3,null,null,"> 30 days",2.284705010217701E-3,null,null,"> 30 days",4.3812423417058317E-4,null,null,"> 30 days",2.039634237676312E-3,null,null,"> 30 days",6.6583789493463157E-4,null,null,"> 30 days",2.2812432803072059E-3,null,null,"> 30 days",5.2061415083575857E-4,null,null,"> 30 days",5.4096390304504065E-4,null,null,"> 30 days",4.406090605018196E-4,null,null,"> 30 days",1.2487302491250431E-3]
[]
[" 0 - 30 Days","Account Balances in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,{"$f":"IFERROR(VLOOKUP($A44,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":1200},{"$f":"IFERROR(VLOOKUP($A44,'[7]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":54706772.930000111},{"$f":"F44/F$50","v":0.99358118572153398},null,1433,63031713.900000118,0.99641548509466593,null,1687,73167476.740000069,0.99296367928244822,null,2069,112464915.77000007,0.9989805161918579,null,2221,126403021.35999995,0.9946939946710619,null,2463,142412596.65000021,0.99510154178687038,null,2677,159431409.03000045,0.99395907270343087,null,2997,213516548.48000023,0.9983235791754147,null,3124,232540319.81999987,0.99809110094502895,null,3255,252870428.10999963,0.99802433659639167,null,3409,273901148.7699995,0.99572850708402028]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP($A45,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":3},{"$f":"IFERROR(VLOOKUP($A45,'[7]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":213175.06},{"$f":"F45/F$50","v":3.8716728758992204E-3},null,3,226750.91000000003,3.5845149053341315E-3,null,5,515588.05999999994,6.9971008959478732E-3,null,3,94573.13,8.4005499473713459E-4,null,7,264948.57,2.0849402857634793E-3,null,2,73271.929999999993,5.1198427827205497E-4,null,8,623157.59,3.8850132735636341E-3,null,2,75656.240000000005,3.5374030182409448E-4,null,6,225774.02000000002,9.6904932598791476E-4,null,3,122576.48000000001,4.8378258797863457E-4,null,8,698753.64,2.5402190604208695E-3]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP($A46,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":2},{"$f":"IFERROR(VLOOKUP($A46,'[7]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":98805.03},1.7944911316239748E-3,null,0,0,0,null,1,2889.9499999999971,3.9219821603790703E-5,null,2,20200.04,1.7942881340492702E-4,null,3,274282.7,2.1583926681241518E-3,null,2,65860.91,4.6020011309502528E-4,null,3,114402.29000000001,7.1322956232640323E-4,null,6,269854.36,1.261738129663169E-3,null,0,0,0,null,4,366338.57999999996,1.4458583433691198E-3,null,3,107754.56,3.9172631309550559E-4]
["4. 91 - 120 Days","91 - 120 Days",null,null,{"$f":"IFERROR(VLOOKUP($A47,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A47,'[7]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":19485.919999999998},{"$f":"F47/F$50","v":3.5390213060543821E-4},null,0,0,0,null,0,0,0,null,0,0,0,null,2,135041.53,1.0626723750505143E-3,null,3,157059.63999999998,1.097447091008368E-3,null,2,231407.13,1.4426844606791444E-3,null,0,0,0,null,3,218970.95,9.3984972898313707E-4,null,0,0,0,null,1,84424.18,3.0691204871061899E-4]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP($A48,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":2},{"$f":"IFERROR(VLOOKUP($A48,'[7]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":21955.150000000009},{"$f":"F48/F$50","v":3.9874814033733028E-4},null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,2,404843.67000000004,2.828826730754329E-3,null,0,0,0,null,1,13034.06,6.0942393097956706E-5,null,0,0,0,null,1,11660.76,4.6022472260565345E-5,null,1,284053.38,1.0326354937528085E-3]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP($A49,'[7]Arrears Reporting'!$A$1:$D$6,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A49,'[7]Arrears Reporting'!$A$1:$D$6,4,FALSE),0)","v":0},{"$f":"F49/F$50","v":0},null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Total",null,null,{"$f":"SUM(E44:E49)","v":1208},{"$f":"SUM(F44:F49)","v":55060194.090000115},{"$f":"SUM(G44:G49)","v":1},null,1436,63258464.810000114,1,null,1693,73685954.750000075,0.99999999999999989,null,2074,112579688.94000007,1,null,2233,127077294.15999995,1,null,2472,143113632.80000019,1,null,2690,160400376.04000044,1,null,3006,213875093.14000025,0.99999999999999989,null,3133,232985064.78999987,1,null,3263,253371003.92999962,1,null,3422,275076134.52999949,1]
["NSW",null,null,null,null,"> 30 days",{"$f":"SUM(G45:G49)","v":6.4188142784659639E-3},null,null,"> 30 days",3.5845149053341315E-3,null,null,"> 30 days",7.0363207175516643E-3,null,null,"> 30 days",1.0194838081420616E-3,null,null,"> 30 days",5.3060053289381449E-3,null,null,"> 30 days",4.8984582131297773E-3,null,null,"> 30 days",6.0409272965691822E-3,null,null,"> 30 days",1.6764208245852203E-3,null,null,"> 30 days",1.9088990549710519E-3,null,null,"> 30 days",1.9756634036083198E-3,null,null,"> 30 days",4.2714929159798024E-3]
[null,null,null,null,null,">90 days",{"$f":"SUM(G47:G49)","v":7.5265027094276855E-4},null,null,">90 days",0,null,null,">90 days",0,null,null,">90 days",0,null,null,">90 days",1.0626723750505143E-3,null,null,">90 days",3.926273821762697E-3,null,null,">90 days",1.4426844606791444E-3,null,null,">90 days",6.0942393097956706E-5,null,null,">90 days",9.3984972898313707E-4,null,null,">90 days",4.6022472260565345E-5,null,null,">90 days",1.3395475424634274E-3]
[]
["VIC","Geographic Distribution"]
["NSW","New South Wales",null,null,{"$f":"F55/F$63","v":0.27131347040988962},{"$f":"IFERROR(VLOOKUP($A$55,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":14938572.339999996},null,null,0.28231473105836191,17858796.48,null,null,0.2930457955421959,21593359.229999993,null,null,0.27640424327859248,31117503.730000027,null,null,0.2757452999894755,35040966.600000016,null,null,0.28264976242011797,40451034.309999987,null,null,0.29348382617420204,47074916.080000021,null,null,0.28280121430693128,60484136.050000042,null,null,0.28479963189832763,66354060.690000072,null,null,0.29110503718246078,73757575.520000115,null,null,0.29705376436823705,81712401.250000164]
["VIC","Victoria",null,null,{"$f":"F56/F$63","v":0.19153753858480085},{"$f":"IFERROR(VLOOKUP($A$56,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":10546094.049999999},null,null,0.19015457514072417,12028886.500000002,null,null,0.19602387984258299,14444206.740000004,null,null,0.18124184772685328,20404150.839999989,null,null,0.17556924411617475,22310864.479999982,null,null,0.17781070148335984,25447135.439999968,null,null,0.18228617183982498,29238770.509999994,null,null,0.17499327888311403,37426703.820000015,null,null,0.17518044582294545,40814427.520000063,null,null,0.17529086308656849,44413621.960000068,null,null,0.18022488506574988,49575564.730000041]
["QLD","Queensland",null,null,9.0775683460726384E-2,{"$f":"IFERROR(VLOOKUP($A$57,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":4998126.7499999981},null,null,0.10274314527741378,6499373.6399999978,null,null,0.11111963029833717,8187956.0499999998,null,null,9.1628113357976035E-2,10315464.5,null,null,9.7444503220291107E-2,12382983.799999997,null,null,0.10632986866643222,15217253.780000001,null,null,0.11191708051559243,17951541.79999999,null,null,9.9631144081146719E-2,21308620.220000017,null,null,0.10433737450900916,24309049.960000016,null,null,0.11345624631120736,28746523.02999999,null,null,0.11757327303315286,32341601.470000003]
["SA","South Australia",null,null,0.21271461431566505,{"$f":"IFERROR(VLOOKUP($A$58,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":11712107.95000001},null,null,0.20473962241892094,12951514.199999997,null,null,0.19709017531594095,14522777.739999989,null,null,0.21358787572077295,24045656.609999996,null,null,0.20501789058552911,26053118.789999969,null,null,0.19685428731566654,28172532.18999999,null,null,0.18950953807252677,30397401.170000002,null,null,0.19954014478003929,42676667.049999997,null,null,0.19173873256753657,44672261.030000031,null,null,0.18459924361716598,46772095.680000022,null,null,0.17919394619319157,49291978.049999982]
["NT","Northern Territory",null,null,6.4718278947134707E-4,{"$f":"IFERROR(VLOOKUP($A$59,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":35634.00999999998},null,null,5.6330816922333684E-4,35634.00999999998,null,null,4.8359297400567356E-4,35634.00999999998,null,null,6.2992828162632152E-4,70917.12999999999,null,null,5.580629526995589E-4,70917.12999999999,null,null,4.9553022037464496E-4,70917.12999999999,null,null,4.4212570912124884E-4,70917.12999999999,null,null,4.9492822397374727E-4,105852.81999999999,null,null,4.5433307107221594E-4,105852.81999999999,null,null,4.1777795548082671E-4,105852.81999999999,null,null,3.848128089369219E-4,105852.81999999999]
["ACT","Australian Capital Territory",null,null,0,{"$f":"IFERROR(VLOOKUP($A$60,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,2.0951485908023851E-4,44810.009999999995,null,null,2.1620857991650131E-4,50373.369999999995,null,null,2.2047574163392924E-4,55862.159999999989,null,null,2.2276559943922353E-4,61277.499999999993]
["TAS","Tasmania",null,null,4.4916972068014737E-3,{"$f":"IFERROR(VLOOKUP($A$61,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":247313.72000000003},null,null,6.0417425738662949E-3,382191.35999999987,null,null,7.7179056976255048E-3,568701.25,null,null,6.703664374150293E-3,754696.44999999972,null,null,7.4465892294538934E-3,946292.40999999992,null,null,8.3530687231636001E-3,1195438.01,null,null,9.1156314972439586E-3,1462150.7199999997,null,null,8.1055238108779046E-3,1733569.6600000001,null,null,8.5949311034376093E-3,2002490.5799999994,null,null,8.8499200193384916E-3,2242313.12,null,null,9.7943024559484972E-3,2694178.8600000003]
["WA","Western Australia",null,null,0.22851981323264528,{"$f":"IFERROR(VLOOKUP($A$62,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":12582345.27},null,null,0.21344287536148954,13502068.620000003,null,null,0.19451902032931187,14333319.730000002,null,null,0.22980432726002875,25871299.68,null,null,0.23821840990637613,30272150.95000001,null,null,0.22750678117088532,32559321.940000027,null,null,0.21324562619148846,34204678.630000032,null,null,0.23422425105483693,50094733.510000005,null,null,0.23467834244775482,54676548.820000008,null,null,0.22606043608614426,57277159.640000015,null,null,0.21555225047534396,59293279.850000016]
[null,"Total",null,null,{"$f":"SUM(E55:E62)","v":1},{"$f":"SUM(F55:F62)","v":55060194.090000004},null,null,1,63258464.810000002,null,null,1,73685954.749999985,null,null,1,112579688.94,null,null,1,127077294.15999997,null,null,1.0000000000000002,143113632.79999995,null,null,0.99999999999999989,160400376.04000005,null,null,1.0000000000000002,213875093.14000005,null,null,1,232985064.7900002,null,null,1.0000000000000002,253371003.93000019,null,null,0.99999999999999989,275076134.53000021]
["AG",null,null,null,null,null,{"$f":"E13-F63","v":1.6391277313232422E-7},null,null,null,1.7136335372924805E-7,null,null,null,1.7881393432617188E-7,null,null,null,1.9371509552001953E-7,null,null,null,2.384185791015625E-7,null,null,null,2.384185791015625E-7,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,275076134.53000009]
["CE","Top Industry Distribution"]
["AGRICULTURAL MACHINERY","Agricultural",null,null,{"$f":"F66/F$69","v":0.99441320095063246},{"$f":"IFERROR(VLOOKUP($A$66,'[7]Top Industry'!$A$1:$C$5,3,FALSE),)","v":54752583.850000106},null,null,0.9933092293454916,62835216.930000126,null,null,0.99073655308781883,73003368.820000067,null,null,0.99146454809879492,111618770.42000005,null,null,0.99051621780298071,125872120.77999991,null,null,0.98945516195435423,141604522.72000027,null,null,0.98777252330436616,158439084.18000039,null,null,0.98851044156697832,211417762.76000017,null,null,0.98745834398168941,230063046.24999982,null,null,0.98669367201571556,249999566.24999967,null,null,0.9852200432911179,271010521.1699996]
["CONSTRUCTION EQUIPMENT","Construction",null,null,{"$f":"F67/F$69","v":5.5867990493674528E-3},{"$f":"IFERROR(VLOOKUP($A$67,'[7]Top Industry'!$A$1:$C$5,3,FALSE),)","v":307610.24000000005},null,null,6.6907706545083811E-3,423247.87999999995,null,null,9.2634469121810406E-3,682585.93,null,null,8.5354519012050805E-3,960918.52,null,null,9.483782197019364E-3,1205173.3799999999,null,null,1.0544838045645617E-2,1509110.0799999994,null,null,1.2227476695633779E-2,1961291.8599999999,null,null,1.1489558433021742E-2,2457330.3799999994,null,null,1.2541656018310655E-2,2922018.5399999991,null,null,1.3306327984284449E-2,3371437.6799999997,null,null,1.4779956708882014E-2,4065613.3599999994]
["MOTOR VEHICLE - AG","Motor Vehicle AG",null,null,{"$f":"F68/F$69","v":0},{"$f":"IFERROR(VLOOKUP($A$68,'[7]Top Industry'!$A$1:$C$5,3,FALSE),)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,"Total",null,null,{"$f":"SUM(E66:E68)","v":0.99999999999999989},{"$f":"SUM(F66:F68)","v":55060194.090000108},{"$f":"F63-F69","v":-1.0430812835693359E-7},null,1,63258464.810000129,-1.2665987014770508E-7,null,0.99999999999999989,73685954.750000075,0,null,1,112579688.94000004,0,null,1,127077294.15999991,0,null,0.99999999999999989,143113632.80000028,-3.2782554626464844E-7,null,0.99999999999999989,160400376.04000041,-3.5762786865234375E-7,null,1,213875093.14000016,0,null,1,232985064.78999981,3.8743019104003906E-7,null,1,253371003.92999968,5.0663948059082031E-7,null,0.99999999999999989,275076134.52999961,-275076134.52999961]
["COMBINE"]
["40-100 HP TRACTOR","Collateral Types"]
["100<140 HP TRACTOR","100-140 HP TRACTOR",null,null,{"$f":"IFERROR(F72/F$107,0)","v":9.1694650798859953E-2},{"$f":"IFERROR(VLOOKUP($A$72,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":5048725.2700000014},null,null,0.1045384063597227,6612939.0999999968,null,null,0.11243649116183835,8284990.1999999909,null,null,9.6654116674627172E-2,10881290.389999991,null,null,0.10036574633027273,12754207.470000006,null,null,0.10385446780441171,14862990.170000002,null,null,0.10853541967793504,17409122.129999995,null,null,9.7898919891032637E-2,20938140.609999999,null,null,0.10117027102679638,23571162.150000006,null,null,0.1031342088663761,26131218.040000021,null,null,0.10702894513296701,29441108.51000002]
["4 EWD Tractors","4 EWD Tractors",null,null,0.12671091530473025,{"$f":"IFERROR(VLOOKUP($A$73,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":6976727.589999998},null,null,0.11763382327330303,7441335.0699999975,null,null,0.11250153408645359,8289782.9499999974,null,null,0.12452306843263165,14018768.310000001,null,null,0.12302718186866371,15633961.379999995,null,null,0.1138365816118113,16291566.739999996,null,null,0.11179989263571301,17932744.819999993,null,null,0.11370035530075473,24317674.080000006,null,null,0.11167033806845429,26017520.950000018,null,null,0.1081672270106003,27406438.900000013,null,null,0.10816969673083333,29754902.050000008]
["40<100 HP Tractor","40<100 HP Tractor",null,null,{"$f":"IFERROR(F74/F$107,0)","v":0},{"$f":"IFERROR(VLOOKUP($A$74,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,""]
["40<60 HP TRACTOR","40-60 HP TRACTOR",null,null,{"$f":"IFERROR(F75/F$107,0)","v":2.5119382938230401E-3},{"$f":"IFERROR(VLOOKUP($A$75,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":138307.81},null,null,2.8841725854080211E-3,182448.33,null,null,3.6417010665115933E-3,268342.21999999986,null,null,3.6172953028590954E-3,407233.97999999992,null,null,4.5266749957370992E-3,575237.61,null,null,5.1911855318370476E-3,742929.42,null,null,6.1717756805827499E-3,989955.14,null,null,5.9419196099104983E-3,1270828.6100000001,null,null,6.8241157922850713E-3,1589917.0599999991,null,null,7.5032547154654967E-3,1901107.1799999995,null,null,8.2621937518615757E-3,2272732.3199999998]
["4WD VEHICLE","4WD VEHICLE",null,null,0,{"$f":"IFERROR(VLOOKUP($A$76,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,1.0632691164254746E-5,783.47999999999956,null,null,1.7351708984034445E-5,1953.4500000000007,null,null,2.4534044579785849E-5,3117.7199999999993,null,null,2.9880801125188112E-5,4276.3499999999985,null,null,4.0777335823507694E-5,6540.6999999999971,null,null,4.7683158661791236E-5,10198.239999999996,null,null,6.1197012833639659E-5,14257.989999999994,null,null,7.2201829397392775E-5,18293.849999999995,null,null,8.1090059078052425E-5,22305.939999999995]
["60<100 HP TRACTOR","60-100 HP TRACTOR",null,null,4.4084461381164022E-2,{"$f":"IFERROR(VLOOKUP($A$77,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":2427299},null,null,4.7696064219425079E-2,3017179.8000000007,null,null,5.4800678279872582E-2,4038040.2999999966,null,null,5.0622335553239459E-2,5699046.7899999991,null,null,5.4170840632888052E-2,6883883.849999995,null,null,5.899669943952391E-2,8443231.9799999911,null,null,6.4113793083848167E-2,10283876.519999996,null,null,5.816084167340374E-2,12439155.430000016,null,null,6.0238977775893862E-2,14034782.139999997,null,null,6.3897213252045268E-2,16189701.07000001,null,null,6.7368036277167365E-2,18531339.010000009]
["BACKHOE","Backhoes",null,null,0,{"$f":"IFERROR(VLOOKUP($A$78,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,4.4010710793599537E-5,2784.0500000000029,null,null,1.5103461762500963E-4,11129.130000000005,null,null,2.5749582604949031E-4,28988.799999999959,null,null,3.6830088576698705E-4,46802.679999999964,null,null,4.5118769425857216E-4,64571.109999999971,null,null,5.1305521864535887E-4,82294.249999999971,null,null,4.6743273623992958E-4,99972.219999999972,null,null,5.0477553188228133E-4,117605.15999999999,null,null,5.3357810445172499E-4,135193.21999999997,null,null,5.5525191329654385E-4,152736.54999999999]
["BALERS, WINDROWERS, MOWERS, RAKES","BALERS, WINDROWERS, MOWERS, RAKES",null,null,2.2060129465119368E-2,{"$f":"IFERROR(VLOOKUP($A$79,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":1214635.01},null,null,2.8073125949766482E-2,1775862.8500000006,null,null,2.9004748153853593E-2,2137242.5600000005,null,null,2.8090297368696927E-2,3162396.9399999995,null,null,2.9796256404646126E-2,3786427.6399999992,null,null,3.5191050646015049E-2,5036319.1000000006,null,null,3.5938161445223014E-2,5764494.6100000013,null,null,3.5847694640073501E-2,7666929.0299999965,null,null,3.6830440044448312E-2,8580942.4599999972,null,null,3.8811712735356309E-2,9833762.6199999955,null,null,3.8551025293848094E-2,10604467.01999999]
["QUAD BIKES","QUAD BIKES",null,null,0,{"$f":"IFERROR(VLOOKUP($A$80,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,1.5304062632948555E-5,2190.2200000000012,null,null,1.3654706142670221E-5,2190.2200000000012,null,null,2.0095467578296438E-5,4297.92,null,null,2.167267676385721E-5,5049.409999999998,null,null,3.2280489373833919E-5,8178.9399999999969,null,null,3.3626544941110479E-5,9249.8599999999951]
["Combines","Combines",null,null,0.37387903693820768,{"$f":"IFERROR(VLOOKUP($A$81,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":20585852.339999989},null,null,0.36205548330631376,22903074.049999986,null,null,0.34101035068694696,25127673.269999988,null,null,0.36262192465070081,40823863.480000004,null,null,0.35181640634958261,44707876.959999993,null,null,0.35399000555592086,50660795.670000024,null,null,0.33796319346833376,54209423.320000008,null,null,0.35899777404066563,76780682.360000014,null,null,0.35489487600644243,82685205.679999977,null,null,0.35462537021333246,89851786.069999963,null,null,0.34717658732253526,95499993.639999986]
["TRUCK - on Farm","TRUCK - on Farm",null,null,0,{"$f":"IFERROR(VLOOKUP($A$82,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,7.0909568484839601E-5,19505.529999999984]
["Cotton Pickers","Cotton Pickers",null,null,0,{"$f":"IFERROR(VLOOKUP($A$83,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,2.5478642323409725E-4,54492.47,null,null,2.3388825394931022E-4,54492.47,null,null,2.1506987443225701E-4,54492.47,null,null,1.9809959192972816E-4,54492.47]
["CRAWLERS / DOZERS","CRAWLERS / DOZERS",null,null,0,{"$f":"IFERROR(VLOOKUP($A$84,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,""]
["CULTIVATORS,SEEDERS, HARROWS","CULTIVATORS,SEEDERS, HARROWS",null,null,1.5996014081613275E-2,{"$f":"IFERROR(VLOOKUP($A$85,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":880743.6399999999},null,null,1.4770473845775265E-2,934357.49999999977,null,null,1.3652612949281226E-2,1006005.8199999998,null,null,1.4897885540382631E-2,1677199.3199999998,null,null,1.5761339610191775E-2,2002908.3899999997,null,null,1.4393876248524657E-2,2059959.9199999995,null,null,1.3615326746212783E-2,2183903.5299999998,null,null,1.6231383977598587E-2,3471488.7600000012,null,null,1.5718765463790314E-2,3662237.59,null,null,1.4877028474187173E-2,3769407.64,null,null,1.4343276441416268E-2,3945493.0400000005]
["Drill","Drill",null,null,0,{"$f":"IFERROR(VLOOKUP($A$86,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,"",null,null,4.7539943042944441E-4,53520.320000000007,null,null,4.2947090084625712E-4,54576,null,null,3.8618102914930686E-4,55267.770000000004,null,null,3.5091925212172345E-4,56287.580000000009,null,null,5.0841492762704235E-4,108737.29000000001,null,null,6.0800837224343892E-4,141656.87000000002,null,null,5.8151196354222859E-4,147338.27000000002,null,null,6.3340747570741303E-4,174235.28000000003]
["DUMP TRUCKS","DUMP TRUCKS",null,null,0,{"$f":"IFERROR(VLOOKUP($A$87,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,""]
["EXCAVATORS / GRADERS","EXCAVATORS / GRADERS",null,null,2.2305419010919441E-3,{"$f":"IFERROR(VLOOKUP($A$88,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":122814.07},null,null,2.4696171566797784E-3,156224.19,null,null,3.2966146781181547E-3,242914.2,null,null,3.1817784661930166E-3,358203.63,null,null,3.540235043355286E-3,449883.49,null,null,3.8915928490077436E-3,556939.99000000011,null,null,4.3991289635383086E-3,705621.94000000006,null,null,3.9802300375517217E-3,851272.07,null,null,4.3004018772751992E-3,1001929.4099999997,null,null,4.5049112262085973E-3,1141413.8799999997,null,null,5.0805466726070482E-3,1397537.1400000001]
["FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE","FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE",null,null,7.4098912425392084E-3,{"$f":"IFERROR(VLOOKUP($A$89,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":407990.05},null,null,6.4624363115333731E-3,408803.8,null,null,5.5479202432401169E-3,408803.8,null,null,3.6312393811806895E-3,408803.8,null,null,4.1357662946322846E-3,525561.99,null,null,4.0132158534654985E-3,574345.9,null,null,3.5902584782992629E-3,575878.80999999994,null,null,2.6996034064707838E-3,577377.93000000005,null,null,3.0051410403970735E-3,700152.98,null,null,2.8129264949232503E-3,712714.01,null,null,2.7273481259355841E-3,750228.38]
["Front End Loader","Front End Loader",null,null,1.8947336042708827E-4,{"$f":"IFERROR(VLOOKUP($A$90,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":10432.440000000004},null,null,2.1820889965413638E-4,13803.560000000005,null,null,2.3754499835669177E-4,17503.730000000003,null,null,1.8802503541541594E-4,21167.800000000003,null,null,1.9512667596447035E-4,24796.17,null,null,2.0207327166668076E-4,28919.439999999995,null,null,2.3904239470385217E-4,38342.489999999991,null,null,2.5730551038954887E-4,55031.239999999991,null,null,2.5786893273245856E-4,60079.609999999993,null,null,4.3116030763402273E-4,109243.51999999999,null,null,5.463704448835379E-4,150293.47]
["Fronts","Fronts",null,null,3.089292415532784E-3,{"$f":"IFERROR(VLOOKUP($A$91,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":170097.03999999998},null,null,2.9779886465126503E-3,188382.99,null,null,2.8539961341818689E-3,210299.43,null,null,3.82000282687937E-3,430054.73000000004,null,null,3.9020588475520315E-3,495863.08,null,null,3.6435980262531629E-3,521448.55,null,null,3.8154678630390568E-3,612002.47999999986,null,null,4.2859136916890651E-3,916650.18999999983,null,null,4.1074477493334783E-3,956973.97999999986,null,null,3.9455556653838287E-3,999689.39999999991,null,null,3.9743435099084167E-3,1093247.0499999998]
["GUIDANCE SYSTEMS","Guidance Systems",null,null,0,{"$f":"IFERROR(VLOOKUP($A$92,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,""]
["HARVESTERS - Other","HARVESTERS - Other",null,null,3.1783850909414767E-4,{"$f":"IFERROR(VLOOKUP($A$93,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":17500.249999999996},null,null,2.8935416082222817E-4,18304.099999999999,null,null,5.0429146403914949E-3,371591.98,null,null,3.3077362666942903E-3,372383.92,null,null,3.4228428679976865E-3,434965.61,null,null,3.0447540284925245E-3,435745.80999999994,null,null,2.7600001379647636E-3,442705.05999999994,null,null,2.9477897624447069E-3,630458.81000000006,null,null,3.288929832007367E-3,766271.53,null,null,3.0498564871830791E-3,772745.2,null,null,2.8119371799433289E-3,773496.80999999994]
["Irrigation Equipment","Irrigation Equipment",null,null,1.4584254800980481E-3,{"$f":"IFERROR(VLOOKUP($A$94,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":80301.189999999944},null,null,1.2694141446712096E-3,80301.189999999944,null,null,1.0897760675347699E-3,80301.189999999944,null,null,1.3919171519785869E-3,156701.59999999998,null,null,1.2331203700536835E-3,156701.59999999998,null,null,1.0949453027929842E-3,156701.59999999998,null,null,9.7694035306327689E-4,156701.59999999998,null,null,1.0725452722531075E-3,229390.71999999997,null,null,9.8457263862282451E-4,229390.71999999997,null,null,9.053550581635412E-4,229390.71999999997,null,null,8.339172003850537E-4,229390.71999999997]
["Other AG","Other AG",null,null,5.3081182300641619E-3,{"$f":"IFERROR(VLOOKUP($A$95,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":292266.01999999996},null,null,5.6018537766345149E-3,354364.67,null,null,6.0883342222012833E-3,448624.71999999991,null,null,6.3640758536990171E-3,716465.68,null,null,5.8471924108208463E-3,743045.39000000013,null,null,5.6513109490432829E-3,808779.64,null,null,6.0085071107293386E-3,963766.79999999981,null,null,5.9477796190476034E-3,1272081.9199999997,null,null,5.6713312983859279E-3,1321335.4899999998,null,null,5.6552530785877429E-3,1432877.1499999997,null,null,5.6825801797411929E-3,1563142.1899999997]
["MATERIALS HANDLING EQUIPMENT","MATERIALS HANDLING EQUIPMENT",null,null,0,{"$f":"IFERROR(VLOOKUP($A$96,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,"",null,null,0,"",null,null,2.9215211297508025E-5,3712.589999999982,null,null,1.0337980883118203E-4,14795.059999999983,null,null,1.6081695465331889E-4,25795.099999999977,null,null,1.7165776276701795E-4,36713.319999999978,null,null,2.0409175173034919E-4,47550.329999999987,null,null,2.3012392537272603E-4,58306.729999999996,null,null,2.5077831676625022E-4,68983.12999999999]
["Other CE","Other CE",null,null,6.0497752597006896E-4,{"$f":"IFERROR(VLOOKUP($A$97,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":33310.180000000008},null,null,5.2657269031186301E-4,33310.180000000008,null,null,1.0222956363335994E-3,75328.830000000016,null,null,8.1055970983037284E-4,91252.560000000012,null,null,7.1808705562384804E-4,91252.560000000012,null,null,6.3762311259001178E-4,91252.560000000012,null,null,8.2073629283244674E-4,131646.41,null,null,6.8779224284760043E-4,147101.63,null,null,6.3137793889316213E-4,147101.63,null,null,5.8057799715961365E-4,147101.63,null,null,9.7246597003792796E-4,267502.18]
["Over 100 HP Tractor","Over 100 HP Tractor",null,null,0,{"$f":"IFERROR(VLOOKUP($A$98,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,""]
["OVER 140 HP TRACTOR","OVER 140 HP TRACTOR",null,null,0.22486690002875739,{"$f":"IFERROR(VLOOKUP($A$99,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":12381215.160000006},null,null,0.2260655447923445,14300559.310000001,null,null,0.23665534794471818,17438175.259999998,null,null,0.22497799717228459,25327952.93999999,null,null,0.22245113288616164,28268488.050000008,null,null,0.2184369717851227,31261308.570000011,null,null,0.2216898750357818,35559139.320000008,null,null,0.2147883046387716,45937868.659999959,null,null,0.21194313641738377,49379585.369999953,null,null,0.21029926587306322,53283736.12000002,null,null,0.21130998019626707,58126332.539999992]
["Rollers","Rollers",null,null,0,{"$f":"IFERROR(VLOOKUP($A$100,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,""]
["SCRAPERS","SCRAPERS",null,null,0,{"$f":"IFERROR(VLOOKUP($A$101,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,2.2373422527988642E-4,16486.070000000007,null,null,2.1724620338074292E-4,24457.510000000009,null,null,2.5380773342081691E-4,32253.200000000012,null,null,2.7863900328578626E-4,39877.040000000008,null,null,2.9509163986122047E-4,47332.810000000012,null,null,2.5540239023645302E-4,54624.210000000006,null,null,2.6505939363822526E-4,61754.880000000005,null,null,2.7125578276110835E-4,68728.350000000006,null,null,2.7464425486813972E-4,75548.08]
["SKIDSTEER / UNILOADER","SKIDSTEER / UNILOADER",null,null,2.4818109027483094E-3,{"$f":"IFERROR(VLOOKUP($A$102,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":136648.99},null,null,3.2301340320813267E-3,204333.31999999998,null,null,4.0900076686595432E-3,301376.11999999994,null,null,3.702776175036037E-3,416857.3899999999,null,null,4.1820602454036388E-3,531444.89999999991,null,null,4.7740996901030367E-3,683238.74999999988,null,null,5.6209815853247172E-3,901607.55999999994,null,null,5.5740383908080161E-3,1192147.98,null,null,6.2756200330604034E-3,1462125.7399999995,null,null,6.8213900296085076E-3,1728342.44,null,null,7.2801913311079866E-3,2002606.8900000001]
["SPRAYING EQUIPMENT","SPRAYING EQUIPMENT",null,null,7.2484652405626862E-2,{"$f":"IFERROR(VLOOKUP($A$103,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":3991019.03},null,null,7.0530881731019998E-2,4461675.3,null,null,6.3782613877307506E-2,4699882.8,null,null,6.44104192174898E-2,7251304.9599999972,null,null,6.7294806334425333E-2,8551641.8999999985,null,null,6.5359010997029177E-2,9353765.4999999963,null,null,6.7679058540940307E-2,10855746.439999998,null,null,6.6724320726109981E-2,14270670.310000002,null,null,6.7403397141163182E-2,15703984.85,null,null,6.5009310909746584E-2,16471474.369999995,null,null,6.2545564119535171E-2,17204792.009999998]
["Trenchers","Trenchers",null,null,0,{"$f":"IFERROR(VLOOKUP($A$104,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,""]
["Under 40 HP Tractors","Under 40 HP Tractors",null,null,2.3514630149753619E-3,{"$f":"IFERROR(VLOOKUP($A$105,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":129472.00999999998},null,null,2.2419973425845774E-3,141825.30999999997,null,null,2.3793558839651208E-3,175325.11000000004,null,null,1.8534605306220703E-3,208662.00999999995,null,null,2.1157199779646301E-3,268859.96999999997,null,null,2.1240490095364275E-3,303980.37,null,null,2.4704593579081236E-3,396262.61,null,null,2.1770098292615055E-3,465608.17999999988,null,null,2.523968437762454E-3,588046.9500000003,null,null,2.6679087169215058E-3,675970.71000000008,null,null,2.8711081437487146E-3,789773.33]
["WHEEL LOADERS (OLD)","Wheel Loaders",null,null,2.6946871955714198E-4,{"$f":"IFERROR(VLOOKUP($A$106,[7]Collateral!$A$1:$C$30,3,FALSE),\"\")","v":14837.000000000015},null,null,4.2043606464182867E-4,26596.14,null,null,4.7976008616486065E-4,35351.58,null,null,3.6559552071542626E-4,41158.630000000005,null,null,3.9207602215127316E-4,49823.960000000006,null,null,4.0831588756930779E-4,58435.570000000007,null,null,4.1766604077844163E-4,66993.790000000008,null,null,3.5300487257101671E-4,75498.950000000012,null,null,3.6032949183102886E-4,83951.390000000014,null,null,3.6449091872215329E-4,92351.430000000008,null,null,3.660782501981017E-4,100699.39000000001]
[null,"Total",null,null,{"$f":"SUM(E72:E106)","v":1.0000000000000002},{"$f":"SUM(F72:F106)","v":55060194.089999989},{"$f":"F69-F107","v":1.1920928955078125E-7},null,0.99999999999999989,63258464.809999987,1.4156103134155273E-7,null,1.0000000000000002,73685954.749999955,1.1920928955078125E-7,null,1.0000000000000002,112579688.93999997,0,null,1,127077294.15999998,0,null,0.99999999999999989,143113632.80000001,2.6822090148925781E-7,null,1,160400376.03999999,4.1723251342773438E-7,null,1.0000000000000002,213875093.13999996,0,null,0.99999999999999989,232985064.78999993,0,null,0.99999999999999989,253371003.93000001,-3.2782554626464844E-7,null,1.0000000000000002,275076134.52999997,0]
["$ 0 - $25,000"]
["$ 25,001 to $50,000","Contract Balance Distribution"]
["$0 - $25,000","$ 0 - $25,000",null,null,{"$f":"IFERROR(F110/F$121,0)","v":0.11656950572147902},{"$f":"IFERROR(VLOOKUP($A$110,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":6418339.6100000003},null,null,0.1225365608109831,7751474.7199999997,null,null,0.12193903167143269,8985193.9700000063,null,null,9.1640217583994266E-2,10316827.18999999,null,null,8.5276164334722196E-2,10836664.219999989,null,null,8.2814595424063553E-2,11851897.599999988,null,null,8.0353090548777067E-2,12888665.940000009,null,null,6.2527897585746922E-2,13373159.920000002,null,null,5.8356590463233785E-2,13596214.010000026,null,null,5.3393036141331653E-2,13528247.169999976,null,null,4.9003300642680409E-2,13479638.519999996]
["$25,001 - $50,000","$ 25,001 to $50,000",null,null,{"$f":"IFERROR(F111/F$121,0)","v":0.20174569402793774},{"$f":"IFERROR(VLOOKUP($A$111,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":11108157.070000006},null,null,0.20118047834743208,12726368.209999999,null,null,0.20217474090610185,14897438.809999995,null,null,0.14351706584134397,16157106.629999999,null,null,0.14288627091113709,18157600.680000011,null,null,0.14119166682211423,20206452.359999992,null,null,0.1399362646406922,22445829.46999998,null,null,0.10913743085886458,23341778.189999968,null,null,0.10680954958391854,24885029.829999991,null,null,0.10454796969316318,26489424.039999973,null,null,9.9211197244098534E-2,27290632.640000023]
["$50,001 - $75,000","$ 50,001 to $75,000",null,null,0.17984351224432815,{"$f":"IFERROR(VLOOKUP($A$112,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":9902218.6899999995},null,null,0.17568538413602386,11113587.689999998,null,null,0.17348689113646854,12783547.209999997,null,null,0.1399743529083515,15758269.109999992,null,null,0.13830024274731523,17574820.629999977,null,null,0.14075857223295915,20144470.619999986,null,null,0.1371419808549221,21997625.299999982,null,null,0.10966828734305424,23455315.170000006,null,null,0.11220120793391745,26141205.700000033,null,null,0.11092138873067157,28104263.620000049,null,null,0.11112488148864204,30567802.850000013]
["$75,001 - $100,000","$ 75,001 to $100,000",null,null,0.1472409295678892,{"$f":"IFERROR(VLOOKUP($A$113,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":8107114.1599999992},null,null,0.14517921811071527,9183814.4599999972,null,null,0.13767554447002667,10144753.939999998,null,null,0.12094571452632764,13616030.920000002,null,null,0.12233354937843298,15545816.440000007,null,null,0.11125040255424221,15921449.259999996,null,null,0.11015107268572716,17668273.480000004,null,null,8.9483799254138838E-2,19138355.900000002,null,null,8.7974366118594841E-2,20496713.390000008,null,null,9.7541995400657389E-2,24714313.300000008,null,null,9.67294360358191E-2,26607959.360000014]
["$100,001 - $125,000","$100,001 to $125,000",null,null,9.4543472576414933E-2,{"$f":"IFERROR(VLOOKUP($A$114,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":5205581.9499999993},null,null,9.240713076988756E-2,5845533.2300000004,null,null,9.8429646119228706E-2,7252882.4499999993,null,null,9.6248134916902178E-2,10835585.089999996,null,null,9.2025126575924571E-2,11694304.079999996,null,null,9.5901539647032172E-2,13724817.729999999,null,null,9.9464214946861695E-2,15954097.48,null,null,0.10475981565246416,22405515.329999998,null,null,0.10359340793691911,24135716.860000011,null,null,9.5646216552448288E-2,24233977.910000011,null,null,9.6812115909297961E-2,26630702.620000008]
["$125,001 - $150,000","$125,001 to $150,000",null,null,7.438201168171725E-2,{"$f":"IFERROR(VLOOKUP($A$115,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":4095487.9999999995},null,null,7.5627239048073253E-2,4784063.04,null,null,7.2567834238450993E-2,5347230.1500000004,null,null,0.10343330275327016,11644489.049999997,null,null,0.10770498955357993,13686858.639999999,null,null,0.10622473277053171,15202207.399999997,null,null,0.10117526380332791,16228550.359999994,null,null,9.7314867684830941E-2,20813226.389999989,null,null,8.9829723200773537E-2,20928983.879999999,null,null,8.7528803556886123E-2,22177260.829999994,null,null,8.9536094151104556E-2,24629242.679999992]
["$150,001 - $200,000","$150,000 to $200,000",null,null,8.2141570779922402E-2,{"$f":"IFERROR(VLOOKUP($A$116,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":4522730.83},null,null,8.597046919071448E-2,5438359.9000000013,null,null,8.9994365717301114E-2,6631320.7600000016,null,null,0.13326560564575674,15003000.429999996,null,null,0.13574083799959938,17249578.399999991,null,null,0.13676067511578119,19572317.039999999,null,null,0.14673692307386196,23536657.640000008,null,null,0.12776416860336806,27325573.460000005,null,null,0.12134083472467028,28270602.239999998,null,null,0.12386445711313716,31383661.849999998,null,null,0.12195206031710987,33546101.349999998]
["$200,001 - $300,000","$200,001 to $300,000",null,null,6.686730115738318E-2,{"$f":"IFERROR(VLOOKUP($A$117,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":3681726.5799999996},null,null,6.9499415978634446E-2,4396426.3599999994,null,null,6.1828216183899005E-2,4555871.1399999997,null,null,0.11335100727450988,12761021.139999995,null,null,0.11843846927563506,15050840.199999994,null,null,0.11954779593855715,17108919.369999994,null,null,0.11147248866512068,17880229.09999999,null,null,0.18862766943877915,40342760.370000012,null,null,0.20016563466003615,46635603.360000014,null,null,0.20142154728999512,51034379.650000043,null,null,0.20571595222786784,56587548.950000048]
["$300,001 - $400,000","$300,001 to $400,000",null,null,1.2881304029562311E-2,{"$f":"IFERROR(VLOOKUP($A$118,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":709247.1},null,null,1.1211892386738431E-2,709247.1,null,null,2.265415187553093E-2,1669292.8099999998,null,null,3.3514038860161029E-2,3773000.07,null,null,3.2136072671316324E-2,4083765.1599999997,null,null,4.3210808006265651E-2,6184055.7100000009,null,null,4.7362722940908153E-2,7596998.5700000003,null,null,7.435760301266095E-2,15903239.270000003,null,null,7.4884423796545599E-2,17446952.330000002,null,null,6.9209609023946031E-2,17535708.119999997,null,null,6.6937862135734841E-2,18413008.369999997]
["$400,001 - $500,000","$400,001 to $500,000",null,null,8.7407897475502722E-3,{"$f":"IFERROR(VLOOKUP($A$119,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":481269.58000000007},null,null,7.6079870329689089E-3,481269.58000000007,null,null,0,"",null,null,8.020127862328771E-3,902903.5,null,null,1.0903520641975875E-2,1385589.9,null,null,9.6817464059231143E-3,1385589.9,null,null,1.4251130928957143E-2,2285886.7599999998,null,null,1.2293809725094392E-2,2629339.7000000002,null,null,1.659202375690615E-2,3865693.73,null,null,2.4220888400061202E-2,6136870.8099999996,null,null,3.0528967532383763E-2,8397790.3800000008]
["$500,001+","$500,000+",null,null,1.504390846581558E-2,{"$f":"IFERROR(VLOOKUP($A$120,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":828320.52},null,null,1.3094224187828499E-2,828320.52,null,null,1.9249577681559459E-2,1418423.5100000002,null,null,1.6090431827053869E-2,1811455.81,null,null,1.4254755910361452E-2,1811455.81,null,null,1.2657465082529865E-2,1811455.81,null,null,1.1954846910843942E-2,1917561.9400000002,null,null,2.4064650840997879E-2,5146829.4399999995,null,null,2.8252237824484445E-2,6582349.46,null,null,3.1704088097702317E-2,8032896.6300000008,null,null,3.2448132315261079E-2,8925706.8100000005]
["$200,001 to $300,000","Total",null,null,{"$f":"SUM(E110:E120)","v":1},{"$f":"SUM(F110:F120)","v":55060194.090000004},{"$f":"F107-F121","v":0},null,1,63258464.810000002,0,null,0.99999999999999989,73685954.75,0,null,0.99999999999999989,112579688.93999997,0,null,1,127077294.15999995,0,null,0.99999999999999989,143113632.79999995,0,null,1,160400376.03999996,0,null,1.0000000000000002,213875093.13999996,0,null,0.99999999999999989,232985064.79000011,0,null,1.0000000000000002,253371003.93000004,0,null,0.99999999999999989,275076134.53000009,0]
["0"]
["0 to 5","Residual / Balloon Payment Distribution"]
["0","0",null,null,{"$f":"IFERROR(F124/F$134,0)","v":0.88905100951851745},{"$f":"IFERROR(VLOOKUP($A$124,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":48951321.14000012},null,null,0.89087951674557875,56355670.560000077,null,null,0.88445078402136057,65171600.450000145,null,null,0.91042462494833754,102495321.08000009,null,null,0.91549979521534364,116339236.77999999,null,null,0.90971063505838146,130191993.78000008,null,null,0.90794935551573808,145635418.05000028,null,null,0.92020285602480889,196808471.54000008,null,null,0.92065457325918065,214498765.3999998,null,null,0.91349637239446979,231453492.9599998,null,null,0.91108591873377298,250617992.7499994]
["0 to 5","0 to 5",null,null,{"$f":"IFERROR(F125/F$134,0)","v":0},{"$f":"IFERROR(VLOOKUP($A$125,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,""]
["6 to 10","06 to 10",null,null,0,{"$f":"IFERROR(VLOOKUP($A$126,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":""},null,null,1.3285851980826765E-3,84044.25999999998,null,null,1.1405736722166825E-3,84044.25999999998,null,null,1.0740779366022637E-3,120919.35999999999,null,null,9.5154182184390313E-4,120919.35999999999,null,null,8.4491852826476446E-4,120919.35999999999,null,null,7.5385957929328918E-4,120919.35999999999,null,null,7.3112113105027593E-4,156368.59999999998,null,null,6.7115289188576202E-4,156368.59999999998,null,null,6.5486858174916053E-4,165924.70999999996,null,null,6.1651978747543712E-4,169589.87999999998]
["11 to 15","11 to 15",null,null,9.0367447522377384E-3,{"$f":"IFERROR(VLOOKUP($A$127,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":497564.91999999993},null,null,9.7740433925652074E-3,618290.98,null,null,1.1194062461408198E-2,824845.17999999993,null,null,8.8644958020080242E-3,997962.17999999993,null,null,8.9593961496103047E-3,1138535.82,null,null,9.6611754795731756E-3,1382645.92,null,null,9.7487815091533599E-3,1563708.2200000002,null,null,8.4681491117549555E-3,1811126.18,null,null,7.9364204382227233E-3,1849067.4299999997,null,null,7.4209404029494516E-3,1880251.12,null,null,7.5261714853500665E-3,2070270.1600000001]
["16 to 20","16 to 20",null,null,4.0663087499116284E-2,{"$f":"IFERROR(VLOOKUP($A$128,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":2238917.4900000002},null,null,3.7421088815702427E-2,2367200.63,null,null,3.6137300236311232E-2,2662811.4699999997,null,null,2.726283860702234E-2,3069241.89,null,null,2.438414486618307E-2,3098671.15,null,null,2.6393070290365785E-2,3777208.1700000004,null,null,2.7729682559414982E-2,4447851.51,null,null,2.4303234068482883E-2,5197856.4499999993,null,null,2.3898543089097571E-2,5568003.6099999994,null,null,2.5339785336185455E-2,6420366.8499999968,null,null,2.4576692454803692E-2,6760461.5600000005]
["21 to 25","21 to 25",null,null,2.0900746882928353E-2,{"$f":"IFERROR(VLOOKUP($A$129,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":1150799.1800000002},null,null,2.0095005527213619E-2,1271179.2,null,null,2.1587311929346972E-2,1590681.6899999997,null,null,1.8958485319119218E-2,2134340.38,null,null,1.9699402450669871E-2,2503346.7599999998,null,null,1.9638036537913933E-2,2810470.7499999995,null,null,1.9443937894648312E-2,3118814.95,null,null,1.6687716964142799E-2,3569087.0200000005,null,null,1.5926640676923207E-2,3710669.4099999997,null,null,1.801105903681377E-2,4563480.1100000003,null,null,1.7524678279475642E-2,4820620.76]
["26 to 30","26 to 30",null,null,2.1106359307423161E-2,{"$f":"IFERROR(VLOOKUP($A$130,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":1162120.2399999998},null,null,2.039941601295395E-2,1290435.7399999998,null,null,1.9841577203693582E-2,1462045.56,null,null,1.4281134768962334E-2,1607765.7099999995,null,null,1.3442784419450689E-2,1708272.67,null,null,1.5216399076692283E-2,2177674.1499999994,null,null,1.5298234085112532E-2,2453842.4999999995,null,null,1.2797145800462133E-2,2736990.7499999995,null,null,1.2633356617313678E-2,2943383.4099999997,null,null,1.1770068175693484E-2,2982193.9899999998,null,null,1.2758596800833152E-2,3509585.4899999998]
["31 to 35","31 to 35",null,null,5.5386168726816289E-3,{"$f":"IFERROR(VLOOKUP($A$131,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":304957.32},null,null,7.6475597606270674E-3,483772.89,null,null,1.1726149344627962E-2,864052.51,null,null,8.2231689278639709E-3,925761.79999999993,null,null,7.3345751195053616E-3,932057.96,null,null,7.4407109872484467E-3,1064867.1800000002,null,null,6.6770381494175354E-3,1070999.4300000002,null,null,6.194212381395948E-3,1324787.75,null,null,5.9579475673737729E-3,1388112.8,null,null,7.4294089726228496E-3,1882396.81,null,null,7.338744356900369E-3,2018713.4299999997]
["36 to 40","36 to 40",null,null,1.1803573357145762E-2,{"$f":"IFERROR(VLOOKUP($A$132,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":649907.04},null,null,1.0738096348690052E-2,679275.49,null,null,1.2394493945265711E-2,913300.12000000011,null,null,9.8759770120928087E-3,1111834.42,null,null,8.7801108559581245E-3,1115752.73,null,null,8.0013246648575013E-3,1145098.6400000001,null,null,9.4127715736993436E-3,1509812.0999999996,null,null,8.2076337371875772E-3,1755408.43,null,null,9.0974037838453588E-3,2119559.21,null,null,1.0027736365215426E-2,2540737.63,null,null,9.3033510681418494E-3,2559129.8500000006]
["41+ %","41+%",null,null,1.899861809949529E-3,{"$f":"IFERROR(VLOOKUP($A$133,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":104606.76},null,null,1.7166881985860804E-3,108595.06,null,null,1.5277471857688013E-3,112573.50999999998,null,null,1.03519667799146E-3,116542.12,null,null,9.4824910143491209E-4,120500.93,null,null,3.0937293767026768E-3,442754.85,null,null,2.9863391335226397E-3,479009.92,null,null,2.4079307807145615E-3,514996.42,null,null,3.2239616761573649E-3,751134.91999999993,null,null,5.849760734300458E-3,1482159.75,null,null,9.2693270332469564E-3,2549770.65]
[null,null,null,null,{"$f":"SUM(E124:E133)","v":0.99999999999999978},{"$f":"SUM(F124:F133)","v":55060194.090000123},{"$f":"F121-F134","v":-1.1920928955078125E-7},null,0.99999999999999967,63258464.810000084,-8.1956386566162109E-8,null,0.99999999999999967,73685954.750000164,-1.6391277313232422E-7,null,1.0000000000000002,112579688.94000009,-1.1920928955078125E-7,null,0.99999999999999989,127077294.16,0,null,0.99999999999999989,143113632.80000007,0,null,1,160400376.04000026,-2.9802322387695313E-7,null,1,213875093.14000008,0,null,1.0000000000000002,232985064.78999978,3.2782554626464844E-7,null,0.99999999999999989,253371003.92999983,0,null,1.0000000000000002,275076134.52999938,7.152557373046875E-7]
["2004 Q1"]
["2004 Q2","Quarter of Maturity Distribution"]
[{"$f":"RIGHT(B137,2)&LEFT(B137,4)","v":"Q12016"},"2016Q1",null,null,{"$f":"F137/F$166","v":0},{"$f":"IFERROR(VLOOKUP($A$137,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["Q22016","2016Q2",null,null,0,{"$f":"IFERROR(VLOOKUP($A$138,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,1.8344364303360051E-5,4647.929999999993,null,null,6.1769767955449084E-3,1699138.8999999994]
[{"$f":"RIGHT(B139,2)&LEFT(B139,4)","v":"Q32016"},"2016Q3",null,null,0,{"$f":"IFERROR(VLOOKUP($A$139,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,1.1973080774573881E-4,27895.49,null,null,3.9449232725783578E-3,999529.16999999993,null,null,4.8508062041800869E-3,1334341.02]
[{"$f":"RIGHT(B140,2)&LEFT(B140,4)","v":"Q42016"},"2016Q4",null,null,0,{"$f":"IFERROR(VLOOKUP($A$140,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,2.0890957128033502E-3,486728.10000000003,null,null,3.701608690231627E-3,937880.31,null,null,4.8468328678458851E-3,1333248.0500000003]
["Q12017","2017Q1",null,null,0,{"$f":"IFERROR(VLOOKUP($A$141,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,1.1642770709803631E-3,186750.48000000004,null,null,3.0521693593030769E-2,6527830.0599999996,null,null,3.3974981302491401E-2,7915663.2200000016,null,null,3.5370445516630329E-2,8961845.2899999972,null,null,3.6769171405151187E-2,10114321.539999995]
["Q22017","2017Q2",null,null,0,{"$f":"IFERROR(VLOOKUP($A$142,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,3.0123768893664757E-4,43111.22,null,null,1.0727677281572532E-2,1720723.4699999995,null,null,1.845025674596416E-2,3946050.3799999994,null,null,1.9217481661477614E-2,4477386.2100000009,null,null,1.9811701229185706E-2,5019710.629999999,null,null,2.6571858669196351E-2,7309284.1700000018]
["Q32017","2017Q3",null,null,0,{"$f":"IFERROR(VLOOKUP($A$143,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,2.5219092216151112E-4,32047.740000000005,null,null,8.8810484028185484E-3,1270999.1000000001,null,null,1.4444395999559403E-2,2316886.5500000003,null,null,1.5275001880941316E-2,3266942.45,null,null,1.6281901560596578E-2,3793439.8899999973,null,null,1.9991140783415694E-2,5065175.4100000029,null,null,2.3447092824028997E-2,6449735.6599999974]
["Q42017","2017Q4",null,null,0,{"$f":"IFERROR(VLOOKUP($A$144,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,1.7942881340492716E-4,20200.04,null,null,9.8762948038521609E-3,1255052.8200000003,null,null,1.5602011257169342E-2,2232860.5099999993,null,null,1.8952690230862632E-2,3040018.6400000011,null,null,2.0060194420074777E-2,4290375.950000003,null,null,2.7109863053638529E-2,6316193.200000003,null,null,3.2315909567387238E-2,8187914.4500000002,null,null,3.3962660759220172E-2,9342317.4399999995]
["Q12018","2018Q1",null,null,0,{"$f":"IFERROR(VLOOKUP($A$145,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":0},null,null,0,0,null,null,2.2812081429941707E-4,16809.299999999996,null,null,6.7393656452929246E-2,7587156.879999998,null,null,7.3140622653622908E-2,9294512.4199999962,null,null,7.1474217025116277E-2,10228934.849999998,null,null,6.833435569544187E-2,10960856.349999994,null,null,9.1285941029234152E-2,19523789.140000008,null,null,9.0217407235719901E-2,21019308.470000025,null,null,8.832679810584361E-2,22379449.510000028,null,null,8.5662956185790576E-2,23563834.860000022]
["Q22018","2018Q2",null,null,0,{"$f":"IFERROR(VLOOKUP($A$146,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":0},null,null,0,0,null,null,2.7500907423609122E-2,2026430.6200000003,null,null,3.9191532784847972E-2,4412170.5699999966,null,null,4.1658737502976731E-2,5293879.6399999969,null,null,4.2861331097452215E-2,6134040.799999997,null,null,5.2526888016141068E-2,8425332.589999998,null,null,5.2339784524009267E-2,11194176.290000016,null,null,5.3928255578635231E-2,12564478.120000014,null,null,5.7405358957406075E-2,14544853.430000002,null,null,6.2640495764712659E-2,17230905.439999994]
["Q32018","2018Q3",null,null,4.2977732627168088E-3,{"$f":"IFERROR(VLOOKUP($A$147,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":236636.22999999998},null,null,2.8327482738985568E-2,1791953.0700000008,null,null,3.9126022859872087E-2,2883038.3499999996,null,null,3.6339461660623087E-2,4091085.2900000033,null,null,3.892293664808702E-2,4946221.4699999979,null,null,4.7645024772231238E-2,6818652.5800000047,null,null,5.0413185240809358E-2,8086293.8700000001,null,null,4.4234706580850644E-2,9460701.9900000058,null,null,4.5136157416264353E-2,10516050.559999995,null,null,4.9380348366368752E-2,12511548.43999999,null,null,5.0724821271175211E-2,13953187.759999996]
["Q42018","2018Q4",null,null,3.9654951931899378E-2,{"$f":"IFERROR(VLOOKUP($A$148,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":2183409.3499999996},null,null,5.1870069244571659E-2,3281220.9499999993,null,null,5.3935599714815409E-2,3974296.16,null,null,4.4288944630654789E-2,4986035.6099999994,null,null,6.0926294671114038E-2,7742348.6699999981,null,null,6.2775757446917393E-2,8984066.6999999993,null,null,6.2560806637370778E-2,10034776.910000002,null,null,5.2776352843532423E-2,11287547.380000005,null,null,5.9721921928951108E-2,13914315.850000001,null,null,6.0417356218982372E-2,15308006.199999999,null,null,5.9473421341885976E-2,16359718.849999998]
["Q12019","2019Q1",null,null,0.22238085521430809,{"$f":"IFERROR(VLOOKUP($A$149,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":12244333.04999999},null,null,0.20857890860345696,13194381.549999988,null,null,0.18766449979397179,13828237.839999987,null,null,0.21980768247803967,24745880.519999992,null,null,0.2140162482194293,27196605.729999989,null,null,0.20360011251143356,29137951.739999983,null,null,0.18956279698756737,30405943.919999991,null,null,0.19833352634583448,42418601.420000009,null,null,0.19573021460025072,45602216.730000041,null,null,0.18515725908778813,46913480.620000012,null,null,0.17303693023506883,47598329.900000013]
["Q22019","2019Q2",null,null,9.413876877236417E-2,{"$f":"IFERROR(VLOOKUP($A$150,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":5183298.8800000008},null,null,9.242324829665749E-2,5846552.7999999998,null,null,0.1010236509149663,7444024.1700000018,null,null,9.301972326092664E-2,10472131.510000004,null,null,8.7466539112843883E-2,11115011.120000007,null,null,9.3908485635199407E-2,13439584.530000001,null,null,9.7663035690723557E-2,15665187.650000002,null,null,9.0966264628414339E-2,19455418.320000011,null,null,8.6736259374456573E-2,20208253.01000002,null,null,8.4227816360138666E-2,21340886.390000019,null,null,8.554092331639114E-2,23530266.53000002]
["Q32019","2019Q3",null,null,6.2341565930357244E-2,{"$f":"IFERROR(VLOOKUP($A$151,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":3432538.7200000007},null,null,6.8167837505255457E-2,4312192.75,null,null,6.75958792540447E-2,4980866.9000000004,null,null,5.6574467916628124E-2,6369136.0000000037,null,null,5.4352019262415827E-2,6906907.540000001,null,null,5.9631082958576109E-2,8534020.9099999983,null,null,5.7769606398486328E-2,9266266.589999998,null,null,4.9961296769630938E-2,10685477.000000002,null,null,4.7992693823865784E-2,11181580.880000008,null,null,4.8981444156998705E-2,12410477.68,null,null,4.8043665047789494E-2,13215665.67]
["Q42019","2019Q4",null,null,5.5635664033308524E-2,{"$f":"IFERROR(VLOOKUP($A$152,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":3063310.459999999},null,null,5.8534747580764122E-2,3702818.2699999996,null,null,5.3632131569822675E-2,3951934.8199999994,null,null,4.0535183503945464E-2,4563438.3499999996,null,null,4.4290868146070701E-2,5628363.6799999997,null,null,4.4652017595908609E-2,6390312.450000003,null,null,4.1334766062809045E-2,6630112.0200000014,null,null,3.4369889789776564E-2,7350863.3799999999,null,null,3.5099802973941503E-2,8177729.8699999992,null,null,3.7240252134797591E-2,9435600.0699999947,null,null,3.6237108453742971E-2,9967963.7200000007]
["Q12020","2020Q1",null,null,0.27779962299075878,{"$f":"IFERROR(VLOOKUP($A$153,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":15295701.160000002},null,null,0.26078990423732362,16497168.980000004,null,null,0.24338262889916615,17933881.379999995,null,null,0.23038707855928817,25936905.640000004,null,null,0.21389422988324674,27181099.970000006,null,null,0.19458423062264696,27847656.13000001,null,null,0.18340161847665462,29417688.570000015,null,null,0.17455914520893603,37333853.43999999,null,null,0.16365833056452878,38129946.749999993,null,null,0.15395259810699038,39007124.339999989,null,null,0.14403823620576159,39621481.239999987]
["Q22020","2020Q2",null,null,0.13712963593368985,{"$f":"IFERROR(VLOOKUP($A$154,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":7550384.3700000001},null,null,0.12728522205185017,8051867.7399999993,null,null,0.12951312909465973,9543298.570000004,null,null,0.10298978047611577,11594557.449999999,null,null,9.5229765474572042E-2,12101540.920000002,null,null,8.7034730558527146E-2,12455856.469999991,null,null,8.616071109804356E-2,13820210.45999999,null,null,7.4256369111685677E-2,15881587.859999998,null,null,7.0667513408381649E-2,16464475.190000001,null,null,6.8949604370776671E-2,17469830.480000008,null,null,6.8689836660254924E-2,18894934.750000007]
["Q32020","2020Q3",null,null,7.4037683981582225E-2,{"$f":"IFERROR(VLOOKUP($A$155,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":4076529.2500000005},null,null,7.3476417803696639E-2,4648005.3900000006,null,null,6.9559315169218205E-2,5125544.55,null,null,5.0056883910946086E-2,5635388.4200000009,null,null,4.6531356440081134E-2,5913078.8700000001,null,null,4.8866277119617635E-2,6993430.4399999985,null,null,4.8487278159874823E-2,7777377.6500000022,null,null,3.9399034344238172E-2,8426472.1400000006,null,null,3.8840104743007531E-2,9049164.3200000003,null,null,3.7625784569389011E-2,9533282.8100000005,null,null,3.6930633685679046E-2,10158735.959999997]
["Q42020","2020Q4",null,null,2.732206097096234E-2,{"$f":"IFERROR(VLOOKUP($A$156,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":1504357.98},null,null,2.5966622410671179E-2,1642608.67,null,null,2.2906637441648947E-2,1687897.4499999997,null,null,1.6662934830098671E-2,1875908.02,null,null,1.6458197775022568E-2,2091463.2400000002,null,null,1.5533069746797737E-2,2222994.04,null,null,1.4132074038496744E-2,2266789.9899999993,null,null,1.1437730191419328E-2,2446245.61,null,null,1.1462148109824332E-2,2670509.3199999994,null,null,1.132738598925438E-2,2870031.1599999997,null,null,1.0647937397421012E-2,2928993.4600000004]
["Q12021","2021Q1",null,null,5.2614169780526481E-3,{"$f":"IFERROR(VLOOKUP($A$157,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":289694.64},null,null,4.5795395267670905E-3,289694.64,null,null,3.9314770499054991E-3,289694.64,null,null,2.5732407215514198E-3,289694.64,null,null,2.9836984845035205E-3,379160.33,null,null,2.6493655606511868E-3,379160.33,null,null,2.3638369146057768E-3,379160.33,null,null,1.7728119924268423E-3,379160.33,null,null,2.0161361434192717E-3,469729.61,null,null,1.853920151533102E-3,469729.61,null,null,1.7076349091591986E-3,469729.61]
["Q22021","2021Q2",null,null,0,{"$f":"IFERROR(VLOOKUP($A$158,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["Q32021","2021Q3",null,null,0,{"$f":"IFERROR(VLOOKUP($A$159,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["Q42021","2021Q4",null,null,0,{"$f":"IFERROR(VLOOKUP($A$160,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["Q12022","2022Q1",null,null,0,{"$f":"IFERROR(VLOOKUP($A$161,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["Q22022","2022Q2",null,null,0,{"$f":"IFERROR(VLOOKUP($A$162,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["Q32022","2022Q3",null,null,0,{"$f":"IFERROR(VLOOKUP($A$163,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["Q42022","2022Q4",null,null,0,{"$f":"IFERROR(VLOOKUP($A$164,'[7]Quarter of Maturity Dist'!$A$1:$C$21,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[]
[null,null,null,null,{"$f":"SUM(E137:E164)","v":1.0000000000000002},{"$f":"SUM(F137:F165)","v":55060194.089999989},{"$f":"F134-F166","v":1.3411045074462891E-7},null,0.99999999999999989,63258464.809999995,8.9406967163085938E-8,null,1,73685954.749999985,1.7881393432617188E-7,null,1,112579688.94,0,null,1.0000000000000002,127077294.15999998,0,null,1,143113632.79999998,0,null,0.99999999999999978,160400376.04000002,2.384185791015625E-7,null,0.99999999999999989,213875093.14000008,0,null,0.99999999999999989,232985064.79000011,-3.2782554626464844E-7,null,0.99999999999999967,253371003.9300001,-2.6822090148925781E-7,null,1.0000000000000002,275076134.52999997,-5.9604644775390625E-7]
["0 to 6 months"]
["07 to 12 months","Seasoning Distribution"]
["0 to 6 months","0 to 6 months",null,null,{"$f":"F169/F$180","v":0},{"$f":"IFERROR(VLOOKUP($A$169,'[7]Seasoning Distribution'!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,4.0425618961819558E-4,111201.23]
["07 to 12 months","07 to 12 months",null,null,0,{"$f":"IFERROR(VLOOKUP($A$170,'[7]Seasoning Distribution'!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,4.4005408712533283E-4,102526.03,null,null,0.20809500054144575,52725239.200000033,null,null,0.33802136640777658,92981610.859999999]
["13 to 18 months","13 to 18 months",null,null,0,{"$f":"IFERROR(VLOOKUP($A$171,'[7]Seasoning Distribution'!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,5.8359906822572582E-4,93609.51,null,null,0.2187050888126619,46775571.240000032,null,null,0.34984872173445203,81509527.100000009,null,null,0.30383246368344619,76982336.350000069,null,null,0.26295157954574017,72331704.070000038]
["19 to 24 months","19 to 24 months",null,null,0,{"$f":"IFERROR(VLOOKUP($A$172,'[7]Seasoning Distribution'!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,6.6451650987844728E-4,84444.959999999992,null,null,0.25563249107879538,36584494.460000016,null,null,0.39506757754855443,63368987.999999963,null,null,0.32144998681542103,68750145.869999945,null,null,0.27839015620362584,64860748.579999998,null,null,0.22389227445170648,56727810.349999987,null,null,0.17982011556369829,49464222.300000034]
["25 to 30 months","25 to 30 months",null,null,0,{"$f":"IFERROR(VLOOKUP($A$173,'[7]Seasoning Distribution'!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0,null,null,9.9645068383944629E-4,73424.42,null,null,0.26619790445478919,29968477.280000005,null,null,0.40640953847328914,51645424.469999999,null,null,0.32963807162891062,47175701.940000035,null,null,0.28118150850689261,45101619.70000001,null,null,0.21238188595558682,45423195.639999986,null,null,0.17242941677918375,40173478.840000048,null,null,0.11676300034779591,29584358.620000005,null,null,0.1087961730708997,29927230.73999998]
["31 to 36 months","31 to 36 months",null,null,1.1270761214274537E-3,{"$f":"IFERROR(VLOOKUP($A$174,'[7]Seasoning Distribution'!$A$1:$C$10,3,FALSE),0)","v":62057.03},null,null,0.30997032253144868,19608246.739999998,null,null,0.4751617658859198,35012748.37999998,null,null,0.360497451557446,40584690.959999986,null,null,0.30155220437532815,38320438.180000015,null,null,0.21857365582854527,31280869.920000024,null,null,0.16501419231959544,26468338.499999978,null,null,0.11607268310457182,24825055.91,null,null,0.10758878094865705,25066579.099999987,null,null,0.10891454500304228,27595787.609999999,null,null,8.3664854856719859E-2,23014204.870000005]
["37 to 42 months","37 to 42 months",null,null,0.46277816944033945,{"$f":"IFERROR(VLOOKUP($A$175,'[7]Seasoning Distribution'!$A$1:$C$10,3,FALSE),0)","v":25480655.829999991},null,null,0.35907045133364185,22714245.510000005,null,null,0.28973314673648864,21349263.540000014,null,null,0.19612599499868549,22079803.510000005,null,null,0.14626667976261226,18587173.889999997,null,null,9.908468126035852E-2,14180368.689999998,null,null,9.4107494961456345E-2,15094877.579999996,null,null,9.6047616243717299E-2,20542192.870000012,null,null,7.179253874095505E-2,16726589.290000001,null,null,1.99023786139047E-2,5042685.6499999985,null,null,8.5730089381592968E-3,2358230.16]
["43 to 48 months","43 to 48 months",null,null,0.32603204014604659,{"$f":"IFERROR(VLOOKUP($A$176,'[7]Seasoning Distribution'!$A$1:$C$10,3,FALSE),0)","v":17951387.409999993},null,null,0.20091033394776439,12709279.290000005,null,null,0.13001096006020055,9579981.7199999951,null,null,9.8613954742021268E-2,11101928.34999999,null,null,9.5039719564642633E-2,12077390.399999999,null,null,7.8156727707634516E-2,11185293.229999997,null,null,5.3696066634233812E-2,8612869.2799999975,null,null,1.8821377519471175E-2,4025423.8699999992,null,null,7.6502906381855874E-3,1782403.46,null,null,1.4788264686495764E-2,3746917.47,null,null,1.100645192347577E-2,3027612.2499999991]
["49 to 54 months","49 to 54 months",null,null,0.12923495508150323,{"$f":"IFERROR(VLOOKUP($A$177,'[7]Seasoning Distribution'!$A$1:$C$10,3,FALSE),0)","v":7115701.709999999},null,null,8.7935771864015272E-2,5562681.9299999988,null,null,7.8070538673450526E-2,5752702.1800000006,null,null,6.6031610941489585E-2,7433818.2199999969,null,null,4.6088506831329278E-2,5856802.7400000002,null,null,1.2538345193903839E-2,1794408.1299999997,null,null,4.6916947365031898E-3,752549.6,null,null,1.405175028039733E-2,3005319.4,null,null,9.4239463889199421E-3,2195638.7599999998,null,null,2.1924617315463297E-3,555506.23,null,null,3.0882081480876466E-3,849492.35999999987]
["55 to 60 months","55 to 60 months",null,null,7.325107705591094E-2,{"$f":"IFERROR(VLOOKUP($A$178,'[7]Seasoning Distribution'!$A$1:$C$10,3,FALSE),0)","v":4033218.5200000009},null,null,4.1602677648035068E-2,2631721.5200000005,null,null,2.6027137960100866E-2,1917834.5099999998,null,null,1.2277981339393106E-2,1382251.3200000003,null,null,3.2112553442175057E-3,408077.64,null,null,6.376027301851845E-3,912496.43000000017,null,null,5.0446914775200561E-3,809170.40999999992,null,null,2.0387586212040772E-3,436039.68999999994,null,null,2.4360944788953732E-3,567573.62999999989,null,null,1.6012665763130828E-3,405714.51999999996,null,null,3.6289038004172353E-3,998224.83]
["60+ months","61 to 72 months",null,null,7.5766821547722622E-3,{"$f":"IFERROR(VLOOKUP($A$179,'[7]Seasoning Distribution'!$A$1:$C$10,3,FALSE),0)","v":417173.59000000008},null,null,5.104426750946944E-4,32289.819999999992,null,null,0,0,null,null,2.5510196617532067E-4,28719.299999999996,null,null,7.6757913870268129E-4,97541.880000000063,null,null,0,0,null,null,6.1317474701850496E-4,98353.460000000021,null,null,4.3085264696848363E-4,92148.649999999965,null,null,0,0,null,null,1.8344364303360051E-5,4647.929999999993,null,null,4.5081555407154198E-5,12400.86]
["61 to 72 months","Total",null,null,{"$f":"SUM(E169:E179)","v":1},{"$f":"SUM(F169:F179)","v":55060194.089999989},{"$f":"F166-F180","v":0},null,0.99999999999999989,63258464.81000001,0,null,0.99999999999999978,73685954.75,0,null,1,112579688.93999998,0,null,1,127077294.16,0,null,0.99999999999999989,143113632.80000007,0,null,1.0000000000000002,160400376.03999993,0,null,1,213875093.13999999,0,null,1,232985064.79000005,0,null,0.99999999999999978,253371003.93000013,0,null,0.99999999999999989,275076134.53000009,0]
[]
[null,"Remaining Term Distribution"]
["0 - 12 months","0-12 Months",null,null,{"$f":"F183/F$189","v":0.44018060162272127},{"$f":"IFERROR(VLOOKUP($A$183,'[7]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":24236429.359999996},null,null,0.40019404780114198,25315661.09,null,null,0.37374064193692214,27539436.030000001,null,null,0.22679043209656952,25531996.299999997,null,null,0.18063152785657319,22954165.799999997,null,null,0.14967483524043418,21420509.409999993,null,null,0.13508706547294203,21668016.09999999,null,null,9.6203302160722107E-2,20575490.20999999,null,null,8.5540618227883045E-2,19929686.479999978,null,null,6.8320924657907817E-2,17310541.269999996,null,null,6.3701946444535792E-2,17522885.189999983]
["13 - 24 months","13-24 Months",null,null,0.54430113270238201,{"$f":"IFERROR(VLOOKUP($A$184,'[7]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":29969326.009999994},null,null,0.51374151376595822,32498499.470000003,null,null,0.46771171421918789,34463784.210000016,null,null,0.40960566585484476,46113278.450000018,null,null,0.41584647359161248,52844644.650000043,null,null,0.41369973070797467,59206071.349999964,null,null,0.39916934025162865,64026912.279999912,null,null,0.26982010767483405,57707800.659999929,null,null,0.22061396530429481,51399758.999999918,null,null,0.20513319734234173,51974804.149999931,null,null,0.18765967606822767,51620698.300000012]
["25 - 36 months","25-36 Months",null,null,1.5518265674896756E-2,{"$f":"IFERROR(VLOOKUP($A$185,'[7]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":854438.72000000009},null,null,8.6064438432899737E-2,5444304.25,null,null,0.15854764384388995,11682734.509999992,null,null,0.36360390204858573,40934414.190000027,null,null,0.39473601906287231,50161985.210000023,null,null,0.38390758710444828,54942409.450000018,null,null,0.3585212092374348,57506936.780000038,null,null,0.3617020437221351,77359058.289999947,null,null,0.38616590038118892,89970887.319999948,null,null,0.38132173970740763,96615872.01000002,null,null,0.37347317387432544,102733557.02000001]
["37 - 48 months","37-48 Months",null,null,0,{"$f":"IFERROR(VLOOKUP($A$186,'[7]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,8.7859794889419245E-3,1116498.5,null,null,5.2717846947142828E-2,7544642.5899999989,null,null,0.1072223850379946,17198510.879999995,null,null,0.27227454644230886,58232743.980000027,null,null,0.30172096328733122,70296478.180000052,null,null,0.30630856130420375,77609707.690000057,null,null,0.29234209738842232,80416334.110000014]
["49 - 60 months","49-60 Months",null,null,0,{"$f":"IFERROR(VLOOKUP($A$187,'[7]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,5.9585527993019499E-3,1388253.81,null,null,3.8915576988139064E-2,9860078.8100000005,null,null,8.2823106224488907E-2,22782659.909999989]
["60+ Months","60+ Months",null,null,0,{"$f":"IFERROR(VLOOKUP($A$188,'[7]Remaining Term'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,{"$f":"SUM(E183:E188)","v":1},{"$f":"SUM(F183:F188)","v":55060194.089999989},{"$f":"F180-F189","v":0},null,1,63258464.810000002,0,null,1,73685954.750000015,0,null,1,112579688.94000004,0,null,0.99999999999999989,127077294.16000007,0,null,1,143113632.79999998,0,null,1,160400376.03999993,0,null,1,213875093.13999987,0,null,0.99999999999999989,232985064.7899999,0,null,1,253371003.93000001,0,null,1,275076134.52999997,0]
[]
[null,"Origination LVR Distribution"]
["01. 10% to 20%","10% to 20%",null,null,{"$f":"F192/F$202","v":0},{"$f":"IFERROR(VLOOKUP($A$192,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,1.5282108311002058E-4,17204.55,null,null,1.3538649932487673E-4,17204.55,null,null,1.2021601061614586E-4,17204.55,null,null,1.0726003532379252E-4,17204.55,null,null,3.1069732816669024E-4,66450.420000000013,null,null,2.8521321767940259E-4,66450.420000000013,null,null,2.6226529069742547E-4,66450.420000000013,null,null,2.4157101128943211E-4,66450.420000000013]
["02. 21% to 30%","21% to 30%",null,null,2.9026566767774357E-3,{"$f":"IFERROR(VLOOKUP($A$193,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":159820.84000000003},null,null,3.4290394281858961E-3,216915.77000000002,null,null,3.0028572032582655E-3,221268.40000000002,null,null,6.5054524212651487E-3,732381.81,null,null,7.1042907072235394E-3,902794.04,null,null,6.9289158593701791E-3,991622.32000000007,null,null,7.6678550285523422E-3,1229926.8300000003,null,null,1.0717623152591841E-2,2292232.6500000004,null,null,1.0644697342447187E-2,2480055.4999999995,null,null,1.0435056454725391E-2,2643940.73,null,null,1.0259362248280455E-2,2822105.709999999]
["03. 31% to 40%","31% to 40%",null,null,3.5955401224412931E-2,{"$f":"IFERROR(VLOOKUP($A$194,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":1979711.3699999999},null,null,3.7733849014032046E-2,2386985.3599999994,null,null,3.5927102104896053E-2,2647322.8199999994,null,null,4.3182335692817035E-2,4861453.92,null,null,4.1787194125443426E-2,5310203.5599999977,null,null,4.0830546368465871E-2,5843407.8199999975,null,null,3.8445270343145516E-2,6166635.8199999994,null,null,4.2196978654697438E-2,9024882.7400000058,null,null,4.1820293926489477E-2,9743503.8899999969,null,null,4.0824645241796152E-2,10343781.349999994,null,null,3.9448241878709926E-2,10851269.889999997]
["04. 41% to 50%","41% to 50%",null,null,9.4234518525650166E-2,{"$f":"IFERROR(VLOOKUP($A$195,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":5188570.879999999},null,null,9.7007279712389219E-2,6136531.5899999999,null,null,9.3268129093489166E-2,6872551.1399999987,null,null,9.746155619463201E-2,10972191.679999998,null,null,9.7454283094880162E-2,12384226.6,null,null,9.8033143562267222E-2,14029879.309999993,null,null,9.5194820903613156E-2,15269285.069999998,null,null,0.10039423349751526,21471826.039999984,null,null,0.10050034147512872,23415078.569999997,null,null,9.8364585108110886E-2,24922733.679999996,null,null,9.5216678447048217E-2,26191835.850000001]
["05. 51% to 60%","51% to 60%",null,null,0.16197864950170573,{"$f":"IFERROR(VLOOKUP($A$196,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":8918575.8800000008},null,null,0.1567796260909608,9917638.4600000009,null,null,0.15084485283133281,11115146.999999994,null,null,0.15967991375052371,17976715.019999981,null,null,0.15815779060179505,20098264.079999991,null,null,0.1544159930653371,22099033.729999997,null,null,0.14876974187422856,23862722.539999988,null,null,0.15200787862997628,32510699.199999988,null,null,0.15107742885461881,35198784.54999999,null,null,0.14916385025826187,37793794.490000017,null,null,0.14652566500858785,40305713.540000044]
["06. 61% to 70%","61% to 70%",null,null,0.22944285756330876,{"$f":"IFERROR(VLOOKUP($A$197,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":12633168.270000005},null,null,0.22234415919269307,14065150.170000011,null,null,0.22466967424344883,16554999.450000005,null,null,0.22085606243992528,24863906.809999999,null,null,0.21594758411717824,27442034.669999998,null,null,0.21099861088845195,30196777.719999991,null,null,0.20681822860394836,33173721.639999993,null,null,0.20715767436743046,44305866.899999976,null,null,0.20428742272771996,47595918.419999972,null,null,0.20322021084237957,51490108.840000011,null,null,0.20239168583317513,55673122.600000009]
["07. 71% to 80%","71% to 80%",null,null,0.19979758157078459,{"$f":"IFERROR(VLOOKUP($A$198,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":11000893.620000007},null,null,0.20208978621907847,12783889.629999997,null,null,0.20621324554392098,15195019.879999995,null,null,0.20620072313729731,23214013.269999985,null,null,0.20814761673077797,26450835.920000006,null,null,0.21194682341960658,30332479.860000014,null,null,0.21512872589148332,34506728.530000001,null,null,0.21148461775486954,45231292.320000015,null,null,0.21294766630092385,49613625.830000058,null,null,0.21043635622460805,53318470.840000071,null,null,0.20993339359908025,57747666.420000069]
["08. 81% to 90%","81% to 90%",null,null,0.18643288967018593,{"$f":"IFERROR(VLOOKUP($A$199,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":10265031.089999994},null,null,0.1895759738403299,11992285.069999989,null,null,0.19547750746895215,14403946.76999999,null,null,0.18351816543933697,20660417.980000008,null,null,0.18445738040728824,23440344.789999984,null,null,0.1843653738206272,26385198.40999997,null,null,0.18899555199571466,30314957.609999996,null,null,0.18035973475765901,38574455.070000015,null,null,0.18029159220081892,42005248.290000066,null,null,0.18133965338312269,45946210.030000038,null,null,0.1855272104837368,51034107.910000041]
["09. 91% to 100%","91% to 100%",null,null,8.9255445267174494E-2,{"$f":"IFERROR(VLOOKUP($A$200,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":4914422.1399999997},null,null,9.104028650233062E-2,5759068.7599999988,null,null,9.0596631510701839E-2,6675699.2899999972,null,null,8.2442969841092575E-2,9281403.9000000004,null,null,8.680847371608845E-2,11031385.949999999,null,null,9.2360377005257649E-2,13218029.080000006,null,null,9.8872545323990382E-2,15859193.449999997,null,null,9.5370561857093444E-2,20397387.79999999,null,null,9.8145343954173694E-2,22866399.32,null,null,0.10595337719629801,26845513.550000008,null,null,0.11045619149009198,30383862.189999998]
["> 100%","> 100%",null,null,0,{"$f":"IFERROR(VLOOKUP($A$201,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,{"$f":"SUM(E192:E201)","v":1},{"$f":"SUM(F192:F201)","v":55060194.090000004},{"$f":"F189-F202","v":0},null,1,63258464.809999995,0,null,1,73685954.74999997,0,null,1.0000000000000002,112579688.93999997,0,null,1,127077294.15999998,0,null,0.99999999999999989,143113632.79999998,0,null,1.0000000000000002,160400376.03999996,0,null,0.99999999999999989,213875093.13999999,0,null,1,232985064.79000008,0,null,1,253371003.93000013,0,null,1,275076134.53000015,0]
[]
[null,"New v Used"]
["New","New",null,null,{"$f":"F205/F$208","v":0.91572064634543693},{"$f":"IFERROR(VLOOKUP($A$205,'[7]New v Used'!$A$1:$C$4,3,FALSE),0)","v":50419756.520000115},null,null,0.91941046095076762,58160494.290000096,null,null,0.91687736990338731,67560984.390000105,null,null,0.91548826311759746,103065383.89000006,null,null,0.91434630598684763,116192654.49000002,null,null,0.91618604115260793,131118712.67000014,null,null,0.9167448678133413,147046221.53000042,null,null,0.9159571391128094,195900418.44000033,null,null,0.91620993548407947,213463231.17999989,null,null,0.91570720063176403,232013652.72999984,null,null,0.91515033407067681,251736016.40999943]
["USed","Used",null,null,{"$f":"F206/F$208","v":8.4279353654563016E-2},{"$f":"IFERROR(VLOOKUP($A$206,'[7]New v Used'!$A$1:$C$4,3,FALSE),0)","v":4640437.57},null,null,8.0589539049232453E-2,5097970.5199999996,null,null,8.3122630096612707E-2,6124970.3600000003,null,null,8.4511736882402544E-2,9514305.0500000101,null,null,8.5653694013152398E-2,10884639.67,null,null,8.381395884739215E-2,11994920.130000003,null,null,8.325513218665874E-2,13354154.510000004,null,null,8.4042860887190679E-2,17974674.699999996,null,null,8.379006451592047E-2,19521833.610000003,null,null,8.4292799368235971E-2,21357351.200000007,null,null,8.4849665929323193E-2,23340118.120000016]
["Used"]
[null,null,null,null,{"$f":"SUM(E205:E206)","v":1},{"$f":"SUM(F205:F206)","v":55060194.090000115},{"$f":"F202-F208","v":-1.1175870895385742E-7},null,1,63258464.810000092,-9.6857547760009766E-8,null,1,73685954.750000104,-1.3411045074462891E-7,null,1,112579688.94000007,0,null,1,127077294.16000003,0,null,1,143113632.80000013,0,null,1,160400376.04000041,-4.4703483581542969E-7,null,1,213875093.14000031,-3.2782554626464844E-7,null,1,232985064.7899999,0,null,1,253371003.92999986,2.6822090148925781E-7,null,1,275076134.52999943,7.152557373046875E-7]
[]
[null,"Contract Type"]
["Finance Lease","Finance Lease",null,null,{"$f":"F211/F$214","v":9.3288023859924452E-3},{"$f":"IFERROR(VLOOKUP($A$211,'[7]Loan Type'!$A$1:$C$4,3,FALSE),0)","v":513645.67000000004},null,null,1.0307448528167956E-2,652033.37000000011,null,null,1.0115998259491908E-2,745406.99000000011,null,null,7.8681212245317756E-3,885790.6399999999,null,null,7.6484473990786174E-3,971944,null,null,9.2389476399343945E-3,1322219.3599999999,null,null,1.1004255560846223E-2,1765086.73,null,null,9.531250507349277E-3,2038497.0900000005,null,null,1.0771847295285167E-2,2509679.5399999996,null,null,1.4017237074930688E-2,3551561.4299999997,null,null,1.5444190486603929E-2,4248328.2200000007]
["Goods Mortgage","Goods Mortgage",null,null,{"$f":"F212/F$214","v":0.99067119761400757},{"$f":"IFERROR(VLOOKUP($A$212,'[7]Loan Type'!$A$1:$C$4,3,FALSE),0)","v":54546548.420000099},null,null,0.9896925514718321,62606431.440000117,null,null,0.98988400174050817,72940547.760000065,null,null,0.99213187877546827,111693898.30000009,null,null,0.99235155260092134,126105350.15999995,null,null,0.99076105236006551,141791413.44000024,null,null,0.98899574443915383,158635289.31000045,null,null,0.99046874949265074,211836596.05000019,null,null,0.98922815270471487,230475385.24999988,null,null,0.98598276292506926,249819442.49999961,null,null,0.98455580951339594,270827806.30999947]
["Hire Purchase","Hire Purchase",null,null,{"$f":"F213/F$214","v":0},{"$f":"IFERROR(VLOOKUP($A$213,'[7]Loan Type'!$A$1:$C$4,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,{"$f":"SUM(E211:E213)","v":1},{"$f":"SUM(F211:F213)","v":55060194.0900001},{"$f":"F208-F214","v":0},null,1,63258464.810000114,0,null,1,73685954.75000006,0,null,1,112579688.94000009,0,null,1,127077294.15999995,0,null,0.99999999999999989,143113632.80000025,0,null,1,160400376.04000044,0,null,1,213875093.14000019,0,null,1,232985064.78999987,0,null,1,253371003.92999962,2.384185791015625E-7,null,0.99999999999999989,275076134.52999949,0]
[]
[null,"Contract by Source"]
["Non Hardship Refinance","Non Hardship Refinance",null,null,{"$f":"F217/F$219","v":0.99775571259705309},{"$f":"E13-F218","v":54936623.190000169},null,null,0.99804657131071473,63134893.910000175,null,null,0.9971097010180221,73472980.310000166,null,null,0.99652371041628507,112188329.3400002,null,null,0.996789267329801,126669282.94000021,null,null,0.99638590223809909,142596406.14000019,null,null,0.99593298322544255,159748025.02000016,null,null,0.99438361815597809,212673888.95000008,null,null,0.99484428673107139,231783860.60000005,null,null,0.99233147151859258,251428021.17000008,null,null,0.99224998041490398,272944289.10000008]
["Refinance - Hardship","Hardship Refinance",null,null,{"$f":"F218/F$219","v":2.2442874029469225E-3},{"$f":"VLOOKUP($A$218,[7]Source!$A$1:$C$228,3,FALSE)","v":123570.89999999997},null,null,1.9534286892853164E-3,123570.89999999997,null,null,2.8902989819779663E-3,212974.43999999997,null,null,3.4762895837150221E-3,391359.59999999992,null,null,3.2107326701989896E-3,408011.21999999991,null,null,3.6140977619009843E-3,517226.66,null,null,4.0670167745574274E-3,652351.02,null,null,5.6163818440219497E-3,1201204.19,null,null,5.1557132689286304E-3,1201204.19,null,null,7.6685284814074321E-3,1942982.76,null,null,7.7500195850959885E-3,2131845.4299999997]
[null,null,null,null,{"$f":"SUM(E217:E218)","v":1},{"$f":"SUM(F217:F218)","v":55060194.090000167},{"$f":"F214-F219","v":-6.7055225372314453E-8},null,1,63258464.810000174,-5.9604644775390625E-8,null,1,73685954.750000164,0,null,1,112579688.94000019,0,null,1,127077294.16000021,-2.5331974029541016E-7,null,1,143113632.80000019,0,null,1,160400376.04000017,2.6822090148925781E-7,null,1,213875093.14000008,0,null,1,232985064.79000005,0,null,1,253371003.93000007,-4.4703483581542969E-7,null,1,275076134.53000009,-5.9604644775390625E-7]
[]
[null,"Payment Frequency Distribution"]
["6 Consecutive","6 Consecutive",null,null,{"$f":"F222/F$228","v":6.8240576737857881E-3},{"$f":"IFERROR(VLOOKUP($A$222,'[7]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":375733.93999999994},null,null,9.7078879774350844E-3,614106.09000000008,null,null,9.2317897258432334E-3,680253.24,null,null,6.4235431524900842E-3,723160.49000000011,null,null,8.0228374135535695E-3,1019520.47,null,null,9.6233876050416303E-3,1377237.96,null,null,9.2022090997586643E-3,1476037.8,null,null,7.2780505534651924E-3,1556593.7399999998,null,null,8.3732950082374986E-3,1950852.6799999997,null,null,9.2367592727641938E-3,2340326.9700000002,null,null,8.8966186549822371E-3,2447247.4700000007]
["Annual","Annual",null,null,0.79784343963978965,{"$f":"IFERROR(VLOOKUP($A$223,'[7]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":43929414.640000083},null,null,0.76833769482051417,48603863.030000076,null,null,0.74631062672089488,54992611.070000045,null,null,0.78845592420589594,88764122.689999908,null,null,0.76958279145341857,97796498.769999951,null,null,0.74940572523849736,107250175.78000006,null,null,0.73136268153601769,117310849.14000005,null,null,0.76407964251839733,163417604.71000046,null,null,0.75049838421018389,174854914.67000023,null,null,0.72680765274497028,184151984.6399999,null,null,0.71388382654687721,196372403.50999993]
["Monthly","Monthly",null,null,0.13046459658783932,{"$f":"IFERROR(VLOOKUP($A$224,'[7]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":7183406.0099999951},null,null,0.15319914305710416,9691142.5999999922,null,null,0.17114168558696713,12610738.499999996,null,null,0.14522905342822323,16349841.659999998,null,null,0.15748740829185437,20013073.70999999,null,null,0.17287343473821717,24740545.25999999,null,null,0.18822304476687188,30191047.160000011,null,null,0.16584759005473004,35470668.769999996,null,null,0.1776888047622909,41398837.690000057,null,null,0.19174234488734965,48581950.420000076,null,null,0.20092981179351313,55270995.939999983]
["Quarterly","Quarterly",null,null,8.711229190656115E-3,{"$f":"IFERROR(VLOOKUP($A$225,'[7]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":479641.97},null,null,9.5603413996287138E-3,604772.5199999999,null,null,1.0153189743395422E-2,748147.47999999975,null,null,9.337861917172929E-3,1051253.5899999996,null,null,1.1076334205131775E-2,1407550.5799999996,null,null,1.1464738529088605E-2,1640760.3799999997,null,null,1.1505099149766303E-2,1845422.23,null,null,1.0142946699174472E-2,2169323.67,null,null,1.0706185618585879E-2,2494381.35,null,null,1.1359311426161268E-2,2878120.14,null,null,1.1294773010056084E-2,3106922.4999999995]
["Semi Annual","Semi Annual",null,null,4.7640362032003801E-2,{"$f":"IFERROR(VLOOKUP($A$226,'[7]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":2623087.5799999996},null,null,4.9915829754705633E-2,3157598.7600000012,null,null,5.3433993267217567E-2,3937334.8100000015,null,null,4.2919240899441095E-2,4831834.79,null,null,4.6051032316062987E-2,5852040.5799999991,null,null,4.8632477031216786E-2,6959970.4599999972,null,null,5.0837205256716526E-2,8154306.839999998,null,null,4.4948916626337265E-2,9613453.7299999967,null,null,4.4744232122330571E-2,10424737.82,null,null,5.1788451821524091E-2,13121692.029999994,null,null,5.576386597917344E-2,15339308.699999997]
["Structured","Structured",null,null,8.5163148759252617E-3,{"$f":"IFERROR(VLOOKUP($A$227,'[7]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":468909.94999999984},null,null,9.2791029906120637E-3,586981.80999999971,null,null,9.7287149556815559E-3,716869.64999999991,null,null,7.6343763967767148E-3,859475.71999999986,null,null,7.7795963199788079E-3,988610.04999999993,null,null,8.0002368579382421E-3,1144942.96,null,null,8.8697601908689361E-3,1422712.8699999999,null,null,7.7028535478958129E-3,1647448.5199999998,null,null,7.9890982783712254E-3,1861340.5799999998,null,null,9.0654798472306012E-3,2296929.73,null,null,9.2311040153978431E-3,2539256.4099999997]
["0% to 1%",null,null,null,{"$f":"SUM(E222:E227)","v":1},{"$f":"SUM(F222:F227)","v":55060194.090000078},{"$f":"F219-F228","v":8.9406967163085938E-8},null,0.99999999999999978,63258464.810000077,9.6857547760009766E-8,null,0.99999999999999978,73685954.75000006,0,null,0.99999999999999989,112579688.93999991,2.8312206268310547E-7,null,1,127077294.15999994,2.6822090148925781E-7,null,0.99999999999999978,143113632.80000007,0,null,1,160400376.04000005,0,null,1.0000000000000002,213875093.14000043,-3.5762786865234375E-7,null,0.99999999999999989,232985064.79000029,-2.384185791015625E-7,null,1.0000000000000002,253371003.92999995,0,null,1,275076134.52999991,0]
["1.01% to 2%"]
["2.01% to 3%","Yield Distribution"]
["01. 0% to 1%",null,null,null,{"$f":"F231/F$245","v":0.12754876160662651},{"$f":"IFERROR(VLOOKUP($A$231,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":7022859.5699999956},null,null,0.12389924737410012,7837676.1799999941,null,null,0.12733935336571045,9383121.8299999982,null,null,0.12228647147299532,13766972.919999996,null,null,0.12045375290039934,15306936.99,null,null,0.11670721637917923,16702393.709999997,null,null,0.11661438639854209,18704991.430000011,null,null,0.11287272293178063,24140664.129999999,null,null,0.11119192937689074,25906058.870000005,null,null,0.10783087530232213,27321217.13000001,null,null,0.108030019073716,29716480.059999984]
["02. 1.01% to 2%",null,null,null,7.1786442553021496E-2,{"$f":"IFERROR(VLOOKUP($A$232,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":3952575.4599999986},null,null,7.5484849724730518E-2,4775055.7100000018,null,null,7.9601470183841255E-2,5865510.3300000001,null,null,8.1559286994419999E-2,9181919.1599999908,null,null,7.8719600351301613E-2,10003473.809999995,null,null,7.7779892468776757E-2,11131362.969999999,null,null,7.7354641156862455E-2,12407713.529999997,null,null,7.4761627570786776E-2,15989650.060000015,null,null,7.3177813759724639E-2,17049337.680000007,null,null,7.7273867949819372E-2,19578957.499999993,null,null,7.5982614252275371E-2,20901003.820000008]
["03. 2.01% to 3%",null,null,null,0.19365141162727068,{"$f":"IFERROR(VLOOKUP($A$233,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":10662484.310000006},null,null,0.20096558805502882,12712774.579999991,null,null,0.20171641366972992,14863666.529999997,null,null,0.20434005091504917,23004539.369999997,null,null,0.20680827242757208,26280635.669999998,null,null,0.21141849471659832,30256868.819999982,null,null,0.21583620172665019,34620207.919999987,null,null,0.22119365179671915,47307812.88000004,null,null,0.2251475247019846,52456010.630000032,null,null,0.22649860702235261,57388179.450000048,null,null,0.23112441436851131,63576810.500000119]
["04. 3.01% to 4%",null,null,null,0.25651660793119446,{"$f":"IFERROR(VLOOKUP($A$234,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":14123854.219999999},null,null,0.24889988979800534,15745024.919999992,null,null,0.23630507210059595,17412364.849999998,null,null,0.24837300292153405,27961755.410000015,null,null,0.2420651816938246,30760988.299999997,null,null,0.23735769000757284,33969121.289999999,null,null,0.22804394461567992,36578334.469999991,null,null,0.23072232360267816,49345758.450000018,null,null,0.22906225018373214,53368083.200000048,null,null,0.22339910590415454,56602855.740000047,null,null,0.21787793231282171,59933019.420000009]
[null,"< 4%",null,null,{"$f":"SUM(E231:E234)","v":0.64950322371811309},{"$f":"SUM(F231:F234)","v":35761773.560000002},null,null,0.64924957495186486,41070531.389999978,null,null,0.64496230931987752,47524663.539999992,null,null,0.6565588123039986,73915186.859999999,null,null,0.64804680737309761,82352034.769999996,null,null,0.64326329357212719,92059746.789999977,null,null,0.63784917389773466,102311247.34999999,null,null,0.6395503259019647,136783885.52000007,null,null,0.63857951802233215,148779490.38000008,null,null,0.6350024561786487,160891209.82000008,null,null,0.63301498000732437,174127313.80000013]
["05. 4.01% to 5%","4% to 5%",null,null,{"$f":"F236/F$245","v":0.21991072461909655},{"$f":"IFERROR(VLOOKUP($A$236,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":12108327.179999996},null,null,0.21870813070716374,13835140.589999992,null,null,0.21496721150919201,15840064.219999999,null,null,0.19463439494559329,21911879.640000001,null,null,0.19275860350912608,24495241.760000024,null,null,0.19145406320787633,27399686.499999996,null,null,0.196806686800583,31567866.570000015,null,null,0.18701554445995164,39997966.989999972,null,null,0.18665176151611632,43487072.750000007,null,null,0.1832869910908593,46439608.940000005,null,null,0.17937746589433282,49342459.940000005]
["06. 5.01% to 6%","5% to 6%",null,null,9.4381145869295288E-2,{"$f":"IFERROR(VLOOKUP($A$237,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":5196644.21},null,null,9.4156698678821468E-2,5956208.209999999,null,null,9.0446547956277892E-2,6664640.2399999965,null,null,0.10169177644558516,11448428.559999997,null,null,0.10616410090549881,13491046.679999996,null,null,0.11069731688063186,15842295.159999985,null,null,0.10802316769930176,17326956.719999984,null,null,0.11377431800378733,24333492.859999996,null,null,0.11480080250683948,26746872.410000004,null,null,0.11610592362071315,29417874.430000003,null,null,0.11612764100593451,31943942.600000001]
["07. 6.01% to 7%","6% to 7%",null,null,2.9668405224468394E-2,{"$f":"IFERROR(VLOOKUP($A$238,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":1633548.1499999997},null,null,3.11665661808526E-2,1971549.1299999994,null,null,3.7916954859026235E-2,2793947.0199999991,null,null,3.4146468481084449E-2,3844198.8000000012,null,null,3.6411479332996842E-2,4627072.2700000005,null,null,3.7262919161954233E-2,5332831.7300000004,null,null,3.8020104132917967E-2,6098439,null,null,3.8925593241240189E-2,8325214.8799999999,null,null,3.8315587645269329E-2,8926959.6700000018,null,null,3.9079290749211147E-2,9901559.1299999934,null,null,3.9109225881704818E-2,10758014.679999998]
["08. 7.01% to 8%","7% to 8%",null,null,2.4764682045456989E-3,{"$f":"IFERROR(VLOOKUP($A$239,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":136354.81999999998},null,null,2.6874582004260948E-3,170004.47999999998,null,null,7.1559887062466283E-3,527295.86,null,null,7.5783767750033718E-3,853171.29999999993,null,null,1.0853045613825491E-2,1379175.6699999997,null,null,1.0915520900675511E-2,1562159.8499999999,null,null,1.2194478705662272E-2,1955998.9700000007,null,null,1.3623119303998447E-2,2913645.91,null,null,1.3609547817401958E-2,3170821.38,null,null,1.7326245513132339E-2,4389968.2200000007,null,null,2.1410064017595442E-2,5889397.6499999994]
["09. 8.01% to 9%","8% to 9%",null,null,4.0600323644808993E-3,{"$f":"IFERROR(VLOOKUP($A$240,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":223546.16999999993},null,null,4.018189198290791E-3,254184.47999999998,null,null,4.3337360706451333E-3,319335.48000000004,null,null,5.2052223231165021E-3,586002.30999999994,null,null,5.565124868881611E-3,707201.01,null,null,5.9894301697860355E-3,857169.1100000001,null,null,6.3970384941249665E-3,1026087.3799999999,null,null,6.5243847682936408E-3,1395403.4,null,null,7.4218315734469265E-3,1729175.9100000006,null,null,8.4567220272449596E-3,2142688.1500000008,null,null,9.6038315519948667E-3,2641784.86]
["10. 9.01% to 10%","9% to 10%",null,null,0,{"$f":"IFERROR(VLOOKUP($A$241,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":0},null,null,1.3382082580451405E-5,846.52999999999884,null,null,2.1725157873454839E-4,16008.389999999992,null,null,1.8494872561867625E-4,20821.469999999979,null,null,2.0083839657355181E-4,25521.999999999982,null,null,4.1745610694888315E-4,59743.659999999974,null,null,7.0935026967534009E-4,113780.04999999996,null,null,5.7625882560959887E-4,123247.40999999997,null,null,5.7982184446785242E-4,135089.82999999996,null,null,6.7482911362358553E-4,170982.12999999998,null,null,8.6659164528139797E-4,238378.68]
["11. 10.01% to 11%","10% to 11%",null,null,0,{"$f":"IFERROR(VLOOKUP($A$242,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,1.0455495154530355E-5,2236.1699999999983,null,null,3.7903588403659055E-5,8830.9700000000012,null,null,6.0229583351282267E-5,15260.430000000008,null,null,1.9725335348596859E-4,54259.689999999973]
["12. 11.01% to 12%","11% to 12%",null,null,0,{"$f":"IFERROR(VLOOKUP($A$243,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,3.2254857223459778E-6,751.48999999999796,null,null,7.3121232156140666E-6,1852.6799999999967,null,null,2.7250579236209519E-4,74959.839999999982]
["13. > 12%","> 12%",null,null,0,{"$f":"IFERROR(VLOOKUP($A$244,'[7]Contract Yield'!$A$1:$C$14,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,2.0440849983613463E-5,5622.7900000000081]
[null,null,null,null,{"$f":"SUM(E235:E244)","v":0.99999999999999989},{"$f":"SUM(F235:F244)","v":55060194.089999996},{"$f":"F228-F245","v":8.1956386566162109E-8},null,1,63258464.809999973,1.0430812835693359E-7,null,1.0000000000000002,73685954.749999985,0,null,1,112579688.94,0,null,1,127077294.16000001,0,null,1,143113632.79999995,0,null,1,160400376.03999999,0,null,1,213875093.14000002,4.1723251342773438E-7,null,0.99999999999999978,232985064.79000011,0,null,1.0000000000000002,253371003.9300001,0,null,0.99999999999999989,275076134.53000015,0]
[]
[null,"Top 5 Obligor",null,null,{"$f":"F247/E13","v":6.224877947937487E-2},{"$f":"SUM('[8]Top 5 Obligor '!$E$2:$E$6)","v":3427429.88},null,null,5.4181363558133279E-2,3427429.88,null,null,4.6514018738421682E-2,3427429.88,null,null,3.0444478149399247E-2,3427429.88,null,null,2.7354625725845672E-2,3476151.82,null,null,2.4578165623925067E-2,3517470.57,null,null,3.0321453041900211E-2,4863572.4700000007,null,null,2.5470126184511721E-2,5447425.6099999994,null,null,2.3381007769360709E-2,5447425.6099999994,null,null,2.4718751091700734E-2,6263014.7800000003,null,null,2.4580872606607657E-2,6761611.4200000018]